dbx driver very very slow when using SQLDataset.open

[eric_lmi]

Hi all

I am using dbx driver for mysql (the latest version) in delphi 7.

when trying to open a SQLDataset (which link to a SQLconnection), it seems really slow and even lost sql connection during the fetch.

trying to fetch 10k records. freeze over 20 mins and finally error reported lost the connection.

it is ok to fetch small amount records, such as 5-20

it only happened under some enterprise network(most under sonicwall firewall system), works fine with standard home internet network system.


any idea what cause it? any solution. is that anything to do with firewall configuration?


Eric

[Dimon]

This problem is not connected with DbxMda. Try to ask this question on the MySQL forum.