Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reindex making DBC grow...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Titre:
Reindex making DBC grow...
Divers
Thread ID:
00886832
Message ID:
00886832
Vues:
69
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
Fil
Voir

Click here to load this message in the networking platform