Confused

[DaveH]

I have two databases accessed by the same program. In database 1, the "names" table contains 242,000 records, in the other there are 196,000. With these numbers being so close, I can't believe the phenomenon I'm witnessing is strictly a matter of table size.

Here's what is happening:

Using dataset 1 (the larger), the program takes 35 Seconds to load and open the table. Then, once opened, attempting to use QBE requires 17 seconds to bring up the QBE mode.

On the other (smaller), the program loads in a few (5-6) seconds, and when QBE mode is called, it activates instantly.

Can anyone give me a clue as to where to start to diagnose the problem. The tables are IDENTICALLY DEFINED... indexes are the same. As near as I can figure, the only difference is the size.

Sonebody... Help!!?!?!?

Dave

 

[DaveH]

Further investigation reveals:

one of the bottlenecks for sure is this line:

LD.Names.Qbemode := true;

Just setting the qbemode requires more than 10 seconds on one dataset, and executes instantly on the other.

Still no idea why... any help GREATLY Appreciated.

FWIW: The same program using BDE components executes the same on both datasets. It isn't great, but it is the same.

DaveH