Devart Forums

Cliant OS WinXP Pro
Delpi 6
MyDac 4.30
MySQL 4.1.18

I am using MYISAM -files.
I have about 200.000 records in file.
Fetch = False

The file have several lookup -fields and few mastar/detail -connects.

Why updating and refreshing takes 20 seconds when I update or refresh the record?
SQL (update, refresh) seems to have no effect to time.

Has it got a primary key ? Is this key in the select statement ??

Whee is located your MySQL server ?, on your workstation, on the local network or on the wan ?

Have you trid to set the compression on ?

Most possible this problem concerns using FetchAll=False mode and MyISAM tables. Please see this topicof MyDAC FAQ.

Thank you everybody for your answers!

I have a primary key and it is in SELECT -statement.

My server is in other machine and I am using TCP/IP in LAN and I have not tried to set the compression on.

The fetch = false and fetchrows = 25. (Fetch=true seems to take too long time when opening tables)

I changed the data type from MyISAM to InnoDB and everything working fine. But I am still wondering why....

Please refer to Locking Issues topic of MySQL Reference Manual for more information.