dbx driver very very slow when using SQLDataset.open

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
eric_lmi
Posts: 3
Joined: Tue 16 Sep 2008 11:20

dbx driver very very slow when using SQLDataset.open

Post by eric_lmi » Tue 16 Sep 2008 11:31

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
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 19 Sep 2008 11:16

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

Post Reply