Sunshine,

If the table being selected from has only 26,000 records and "Creating the tables takes forever", my first question is: do you have the required fields defined as indexes in the subject table?

If your answer is 'yes' then the next question is: do your WHERE clauses use EXACTLY the same expression (on the left side) as the expression for the TAG?

26,000 records should return instantaneously for virtually any query that has proper Rushmore optimization.

A few other questions are:
1) what version of VFP?
2) What OS?
3) What RAM on the machine running so slow?
4) Can you show us the Select statements that are running so slow?

good luck



>Thanks to everyone that answered my last "What's faster?" question.
>
>Here's another.
>
>Selecting the records need into another table or using set filter to?
>
>More info: The table I am selecting from has over 26000 records. The program currently searches the table for particular records 3 different times and stores the results into 3 different tables which are accessed numberously through out the program. Creating the tables takes forever! 2 of the created tables have under 1000 records, 1 has just over 1500.
>
>A little background info: I'm a consultant at a state agency hired to patch the existing system written in 2.6 and grossly outdated.
>
>Thanks again,
>Sunshine