Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: VFP7 SP1 REINDEX no longer removes BLOAT from .CDX
Message
From
08/05/2002 07:28:11
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00652071
Message ID:
00653904
Views:
36
>It's already late here and I'm not sure I really understand what you are asking. "CDX bloat" as "formerly used but now unused space" hasn't changed in SP1. REINDEX still creates the index from the scratch using the definition stored in the index, INDEX ON still adds to the index file and DELETE TAG leaves the space in the file. What has changed is the way index nodes are created. I think in most database systems this is called a "fill factor".
>

So would it be fair to assume that the latest version of the VFP indexer works "more similarly" to the file system and indexer in SQL Server which allocates a fill factor in order to increase performance for OLTP?

Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Previous
Reply
Map
View

Click here to load this message in the networking platform