MySQL Forums
Forum List  »  Connector/ODBC

ADO/MyODBC speed problem opening table on high performance PC
Posted by: Frederic Vicinenzo
Date: November 09, 2004 11:22AM

Hi everybody,

I have performance problem when I open table on a high speed PC.
My P4 Mobile is six times faster than a Bi-Pentium Xeon !

I use the same test program to open the same table.
The test program is written in Visual Studio C++ using ADO Connection.

My connection string is : DRIVER={MySQL ODBC 3.51

Driver};Server=localhost;Port=3306;Option=40;Uid=root

My recordset parameters are :
Cursor Location : adUseClient
Cursor Type : adOpenStatic
Lock Type : adLockOptimistic

I use Open() method with simple command "SELECT * FROM xxxxx"

The 2 PC have the same operating system, same version of software and same configuration

file for server :
Windows XP Pro SP1
MySQL Server 4.1.7
MyODBC 3.51.10


The result for test program is (opening same table with 348529 records) :

Time for Notebook P4 Mobile 1.7GhZ : 29s
Time for Bi-Pentium Xeon 2.8Ghz (Hyperthreading or not) : 165s

Where is the difference ? (except PC type).

Does anybody know why this happens?

Thank you by advance

F. Vicinenzo

Options: ReplyQuote


Subject
Written By
Posted
ADO/MyODBC speed problem opening table on high performance PC
November 09, 2004 11:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.