TIP: Click on subject to list as thread! ANSI
echo: paradox
to: KENNETH ULLMAN
from: RICH GORIN
date: 1995-04-24 23:39:00
subject: Qbe

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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.