program hangs for 10 seconds then comes back...

[markcr1967]

Using MyDAC 4.nn in C++ Builder 6 SP2 my application performed fine.
I was able to scroll thorugh thousands of records using Next()

Now, using 5.nn in C++ Builder 6 SP" my application hangs for 10 seconds after about 30 seconds of Next() The cursor if in an edit control stops blinking and to all intents the program has stopped running. 10 seconds later it caries on where it left off and after a short time does it again.

It is the same app, talking to the same database but under 5.nn hangs.

Any ideas>

[Antaeus]

Do your dataset have calculated or lookup fields? What is the value of its FetchAll property?

[markcr1967]

The program has 10 TDBLookupComboBox controls, these look at 10 different tables with a max row count of 30 per table.

Can you think of a better way of using lookups?

[Antaeus]

We recently fixed similar problem with performance loss when working with lookup fields. Try to download the last build of MyDAC and test it. The last MyDAC build is 5.10.0.10.