Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select in large tables
Message
From
06/07/2001 09:52:31
Krasimir Georgiev
Kag Soft
Sofia, Bulgaria
 
 
To
06/07/2001 09:03:47
Unknown Member
New Brunswick, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL Select in large tables
Miscellaneous
Thread ID:
00527385
Message ID:
00527417
Views:
16
I remove !deleted() clause -: Don't work
I rename ".. as TO;" clause to ".. as TO1;" -: Don't work
I delete and recreate indexes -: Don't work

I test this SELECT comand with two sets of tables : small , and bigger.
With small /500,26000 recs/ it work, but with large /5000, 50000/ - not.
--------------
Krasimir Georgiev.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform