In a message to ALL, KENNETH ULLMAN said:
KU> I'm trying to a a query that has 3 parameter selections and joing
KU> 1 other file. On a file of <=9000 records it take about 4 to 5
KU> minutes to finish the query. This seems a bit long. Is there any
KU> optimation or efficiency I need to know about? I do have 6mg of ram
KU> with 7mg of swap file space. I'm use a 386-30 if that's of help.
KU> thank you for any help you can give me in this matter.
A faster computer would help. If this is Paradox 5 for Windows,
Borland is recommending 8 megs of RAM as a minimum.
Short of hardware changes, you might want to create secondary indexes
on the fields that are joined and see if that helps.
Rich
---
---------------
* Origin: Recovery BBS, San Francisco, CA - 415-255-2188 (1:125/9)
|