Information générale
Titre:
Reindex making DBC grow...
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement