Hallo Mechtilde ,

Our Mysql server is based on a MS-server who I accesed via our Intranet.

Your results confirms the slowness off the Native Connector. I never used JDBC but 9 seconds for 16.000 records is also very slow no ?

Using the latest MySql connector ODBC 5.1.5 for windows (dowloaded from the MySql site) it takes a blink ( 1sec) to read all 28.000 records. Same situation for the Beamer (F4). Ones the records are read in to the memory then the speeds seems to bee the same....

Greetz

Fernand




Hello,

Fernand Vanrie schrieb:
We did some tests with the latest MySql-connector Beta on Windows and
found that in a real live situation that opening a table with 28.000
records takes  35 seconds before  the whole table is loaded in memory.(
going to the last record)

I did a similar test: 16443 records need nearly 8 s using table view.

With a ODBC connection  it takes 1 second.
I can't test it with ODBC because my configuration is defect.

with JDBC I meassured 9 s
Are we doing something wrong with our native connection  or can this
behavior  been confirmed ?
Is it a local connection or via Intranet or maybe via internet?

Regards

Mechtilde



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to