Hello,
I'm currently in the process of switching databases from Sybase SQL Anywher=
e to MySQL. I have installed MySQL for Windows version 4.1.9 and MyODBC 3.=
5.11.
I have a test query that returns 38,400 rows with 3 columns of data (an int=
, a double, and a datetime). The query itself takes about 1.5 seconds. Ho=
wever, 15 seconds are needed to load the data. This seems quite high consi=
dering that SQL Anywhere was returning the same dataset in 6 seconds (using=
ODBC as well).
I've increased the buffer sizes, changed the connection type from TCP/IP to=
named pipes, disabled the dynamic cursor, and tried a variety of MyODBC co=
nnection switches but with the same results. Any other ideas?
Ian
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg
