You did not tell what kind of DB operation you are actually trying to
Record count of 38.000 is peanuts, if you have any indexed field there,
and you can seek the data by using that index. Paradox always requires
the Primary Index, and then you can add Secondary indexes as much as
With indexed searches, that is using FindKey for instance, you should
always get a couple of seconds response time with local databases.
If you use SetRange with indexed field, you should get the table
open with that selected dataset in some seconds. Filter is not as effective,
if you do not know what you are doing.
If there are a bunch of Master/Detail connections with this table that you
are opening, they can also cause some slowness when they get open.