Hi !! > -----Original Message----- > From: m.colurcio@ [mailto:[EMAIL PROTECTED]]On Behalf Of Massimo > Colurcio > Sent: Friday, March 15, 2002 1:59 AM > To: [EMAIL PROTECTED] > Subject: Slow query > > > Hi all. > > I'm using MySQL server 3.23.47 (client 3.23.44) on Windows 98 (...sorry) > accessing to database via ODBC (MySQL ODBC release 3.5.01.01) and > VC++6.0 & MFC > (CRecordset). > I have noticed that queries are really slow... with a simple > SELECT like this: > > SELECT > ID_Field, Text_Field, Date_Field, Num_Field > FROM > mytable > ORDER BY > Num_Field > > the server takes about 31 seconds to show all the 2872 records. > > I tried to modify some parameters in the DSN and I noticed that > checking 'Use > compressed protocol' the same query takes only about 6 seconds to > complete and I > said "That's great" :)))) > I have used for the tests WinSQL (www.indus-soft.com/winsql) and > -of course- > the program I'm developing. > > Now I would like to know: > Am I doing something wrong?
No. There is nothing wrong in using the compressed protocol. Also, the current dynamic cursor behaviour slows down the performance drastically. I am working on this to have a different logic, and probably included in the next 3.51.03 version. I recommend you to use 3.51.02 instead of .01 as the new one has lot of fixes and improvements on Windows. 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
