Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL select is slow in large tables
Message
From
19/06/1998 12:18:00
David Frankenbach
Austin, Texas, United States
 
 
To
19/06/1998 11:28:40
Bernard Bout
Zest
Brisbane, Australia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: SQL select is slow in large tables
Miscellaneous
Thread ID:
00109911
Message ID:
00109948
Views:
50
Bernard,

Is SET DELETED ON? if it is do you have an index: INDEX ON DELETED() TAG DELETED?

>There is an index on inv_number and even if I do a select as so
>
>SELECT * from inv_table WHERE BETWEEN(inv_number,20000,60000) into...
>
>it is still sloooow!
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform