I'm not sure if this is the proper group to post this in - if there is a
better one please direct me to it.

I have a small application that uses 3 paradox tables. The main table is
filtered by account #. The PK is account # + trans #, plus there are two
other indexes on this table. This table has 8050 records, with 7116 records
in the largest account.

Lately, when being filtered by the largest account, all data activity has
become real slow - going into insert mode, or posting, or even record
navigation (first to last, last to first) takes several seconds. For the
other accounts (and how this one used to behave), these activities are
instantaneous.

What should I look at for regaining performance?

Thanks,
Wayne

 delphi.database.desktop would be better, that one deals with desktop
databases like Paradox.

Peter Below (TeamB)  100113.1...@compuserve.com)
No e-mail responses, please, unless explicitly requested!
Note: I'm unable to visit the newsgroups every day at the moment,
so be patient if you don't get a reply immediately.