Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up
Message
From
17/11/2003 18:09:31
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
How to speed up
Miscellaneous
Thread ID:
00850812
Message ID:
00850812
Views:
77
I had a large table (over 3 million records) with multiple indices which accidentily wound up with some duplicate entries. I tried to rectify this by creating a new unique index, copying to a temp file, zapping, appending from the temp file, and eliminating the new index. This worked fine, but now all sql commands I run on the table are taking much much longer than they had! Any thoughts? Thanks!!!!!
Next
Reply
Map
View

Click here to load this message in the networking platform