General information
Title:
SQL Passthrough very slow
str1="Driver={MySQL ODBC 3.51 Driver};Server=x;Database=x;Uid=root;Pwd=123"
nHandle=sqlstringconnect(str1)
x=sqlexec(nHandle,'select * from testtable')
I noticed that it takes one full second for just 200 records to be
returned. for 20000 records it takes 100 seconds.
The database server is not in a network so the delay is in the ODBC translation. Is this normal? Can sql passthrough not use odbc and use oledb drivers instead? i cant find the connection string to make connection to
mysql faster..also numeric fields are returned as strings so i have to use
val()..
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only