Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindex making DBC grow...
Message
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Reindex making DBC grow...
Miscellaneous
Thread ID:
00886832
Message ID:
00886832
Views:
67
I am using the latest Stonefield Database Toolkit - 6.1c

I have the following code to reindex my tables:

open database EDWIN excl
oMeta = newobject('DBCXMgr', 'DBCXMGR.VCX')
oMeta.SetDatabase(dbc())
oMeta.oSDTMgr.Reindex('ALL',.T.,.t.)
oMeta.oSDTMgr.Reindex('!ALL', .T.,.t.)
close database all

This code is compiled into a VFP 6 executable called Newcdx.exe. Every time I run the Newcdx.exe, my EDWIN.DBC increases in size by 78kb or 79kb, EDWIN.DCT increases in size by 31kb, and EDWIN.DCX increases in size by 2kb. I repeat, every time I run Newcdx.exe, I get these increases. I actually saw a 12+meg EDWIN.DBC on a client's computer!

Why does the Reindex() function increase the size of my DBC/DCT/DCX? Should I be issuing some type of PACK DATABASE?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform