Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very Poor Performance of SQL on Local Table
Message
From
12/02/2002 14:59:17
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00618884
Message ID:
00619057
Views:
19
>Hi Renoir,
>
>Note how long will take to do
SELECT * FROM data\Employee.dbf INTO CURSOR temp NOFILTER
Multiply that time by .7 ( 70% records you extract with your query). That should give you an estimate of the min time your query could take.

Hey Sergey,

Cool. Yeah, that's also kind of the bad news; it's really not going to run much faster. I think I'm going to have to revamp how I handle the data when the form intializes.

Renoir
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform