General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only