Hi, > -----Original Message----- > From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 03, 2002 2:00 PM > To: 'Alexander Shaw'; MySQL List > Subject: RE: Any ideas how to speed this up? > > > What version of the ODBC Drivers are you using? > > I had a VB app using the 3.5x versions of the ODBC driver > manipulating very > small tables and it was absolutley painful to run.
Hmm, I don't *really* agree on this lines. The 3.51 is using the same 2.50 code base with extensions that will not cause the performance issues like this. There is a chance that you enabled OPTION=32 from 3.51 which causes this issue, as this option will enable the driver to fetch the latest data from server. Make sure you turn off this option as well as other debug options, if there is any. If you still feel the driver is talking extra time, then please let me know, so that if there is anything we can incorporate in 3.51.03, which will have lot of code cleanups. Also, the performance will be increased drastically with 4.1 protocol, which is tuned to have best performance from all client APIs with lot of advanced features. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php