Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough very slow
Message
From
27/04/2006 01:18:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Passthrough very slow
Miscellaneous
Thread ID:
01116979
Message ID:
01116979
Views:
85
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
Map
View

Click here to load this message in the networking platform