Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to speed up
Message
From
17/11/2003 18:14:14
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
17/11/2003 18:09:31
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00850812
Message ID:
00850814
Views:
16
>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!!!!!

Compare the indices in the new and old tables. Indices can have a significant impact (sometimes positive, sometimes negative) on performance.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform