Slow updating and refreshing

mydac4std · Post by **mydac4std** » Mon 08 May 2006 05:43

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.

GEswin · Post by **GEswin** » Tue 09 May 2006 21:29

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

swierzbicki · Post by **swierzbicki** » Wed 10 May 2006 04:47

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 ?

Antaeus · Post by **Antaeus** » Wed 10 May 2006 12:16

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

mydac4std · Post by **mydac4std** » Sat 13 May 2006 05:49

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....

Antaeus · Post by **Antaeus** » Mon 15 May 2006 08:41

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

Devart Forums

Slow updating and refreshing

Slow updating and refreshing

Everything workin in InnoDB