Displaying 2 results from an estimated 2 matches for "t304".
Did you mean:
304
2008 Oct 17
0
Excessive query time running R-RODBC against SQL Server
...setup:
Core 2 Duo 2GHz, Win XP, 2GB RAM
R 2.7.1
RODBC (latest from CRAN, not sure the version - how to tell?)
SQL Server 2005
MS Access 2003
SQL Native Client ODBC driver (DSN = "HIM")
SQL Server ODBC driver (DSN = "HIMs")
MS Access ODBC driver (DSN = "HIMa")
Table (T304) being queried has ~290K rows, of which the query being run
should return ~78K.
Table being queried has 142 columns, of which all but 5 are type float. The
other 5 are nvarchar(255)
No indices or keys - one flat table
No UPDATEs, INSERTs, just SELECT
R code looks like this:
him <- odbcConnect(...
2009 Dec 22
2
E1 R2 Congestion Status
...tual connect = disabled
ISDN Layer 2 is DOWN
ISDN Values
ISDN Layer 2 values
k = 7
N200 = 3
N201 = 260
T200 = 1 seconds
T203 = 10 seconds
ISDN Layer 3 values
T301 = 180 seconds
T303 = 4 seconds
T304 = 20 seconds
T305 = 30 seconds
T306 = 30 seconds
T308 = 4 seconds
T310 = 10 seconds
T313 = 10 seconds
T316 = 120 seconds
T322 = 4 seconds
T309 = 90 seconds
N303 = 1
---------------------------
/etc/asteri...