cacheupdate is slower than previous version?

[anwar5218]

I have litte problem and I dare not say it's your component matter.
I have several complains from my customer that when they enter data
for over 60 records, it goes slow.

I detecting like this:
I have 2 table (TmyTable) component for example tmast dan tsub.
tmast is master of tsub, tsub's cacheupdate is true. but I don't
use mastersource to connect master/detail. I open tsub with filtersql.
The problem is when user enter more then 60 records in tsub, when
the move down to next record, it move slow (needs more than 3 seconds
depend on computer speed). First i think that may be filtersql makes that problem, than i replace tsub with virtualtable dan the same problem still happen.

This complains I receive after upgrading to mydac ver 4.xxx. I use ver 3.xx
for about a years using ver 3.xx and none is complaining this problem. I use devexpress
grid ver 5.xx. I did'nt change my grid component since ver 3.xx up to now.

The strange case is that not all my customer (who have large data) have
this problem. so i cannot prove to you too. But all customer complain
have the same point.

My Question is: Is it posible that your ver 4.xx is slower than 3.xx since
you add many feature in this 4.xx? What solution for that?

[Antaeus]

We made some optimizations in MyDAC 4 to improve its performance. So if this is a MyDAC problem, it should be fixed. Please send me to EvgeniyD*crlab*com a complete small sample to demonstrate this problem, including script to create and fill table. Do not use third party components.
Also supply us the following information:
- Exact version of Delphi, C++ Builder or Kylix.
- Exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor.
- Exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor.

[anwar5218]

I use borland delphi 6.
MyDAC version 4.40.0.20
MySQL server version: 5.0.22-community-nt
MySQL client version: Direct

I already try re-produce this error with auto generate up to 10000 records. But it works fine. But when i use my customer's data, i shown up this error. I could not email you my customer's data since the data size is over 100mb and it's confidential. I already try to repair mysql table too.

[anwar5218]

ok, i already found out reason of my problem.
In some condition, i use .last and .enablecontrol statement. This two statement makes it slow down.

my conclusion is i will try to avoid using disablecontrol and enablecontrol

Thanks