Hi, > -----Original Message----- > From: Rachman M.H [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 18, 2001 11:02 PM > To: [EMAIL PROTECTED] > Subject: Benchmarking > > > Dear all, > > I've been trying benchmark MySQL, SQL Server 7, and M$ Access 97. > But, SQL Server 7 and M$ Access is won when connected and opening > recordset using ADO, Even i'm using MyODBC with TCP/IP connections. > > If i'm use cursorlocation=serverside with adOpenDynamic, and > adLockOptimistic, > still MyODBC is looses.
Something interesting. When I did a small research on this, I got MyODBC as the best result for most of the cases. Is it possible for you to pass the following info, so that we can also cross check: 1. Test scenarios 2. Comparision analysis for various tools/applications 3. MyODBC version and the DLL type (debug/share version) 4. MySQL version > > How can i make speed up the connection and opening recordset for MySQL ? It also depends up on your SELECT query and how the table is structured. You can find more information on this in the manual ( 5. MySQL optimisation). 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
