Time accessing records 1

[teknik]

I have a table in Foxpro 2.5 which has about 20,000 records. When I try to access some records (ie records meeting some criteria) by using a pop up (DEFINE POPUP PROMPT <table name.field name) or a SQL query it takes a lot of time to get the records from the table. Is there an method by which the time can be reduced.

 

[ramani]

Index the DBF on the field name or combinatio of field name you are using for the extraction. Then remember to set the order to that index when you open the file.

When the index exactly matches the expression you use to filter in an SQL statement, the access will be rushmore optimised. The results will be alomost instantaneous and will not disappoint you for sure.

Best of luck. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[teknik]

Even if the dbf is indexed it does not work specially when two dbfs are joined in a SQL query

 

[tesar]

Creating popup menu from 20000 records (I think)
is strongly unusually. I use only BROW,
and i have no time problem.