Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No (more?) bloat with REINDEX command
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00523073
Message ID:
00523146
Views:
23
>Jim,
>
>With SP5 I just used REINDEX on a table with 214,319 records with 15 tags and I get 15 distinct sets of .....GENERATING ......INDEXING messages on the status bar. It would appear that there must of been 15 different reads of the dbf to create the cdx file. I agree that the bloat issue seems to be a obsolete problem as my cdx file went from 20762kb to 13161kb and is holding there after 5 REINDEX commands.
>
>How are you determineing that only one read pass of the dbf is necessary?


That was confirmed by MS when SP3 shipped.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform