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:
users-unsubscribe@...
For additional commands, e-mail:
users-help@...
