Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DCT file
Message
 
À
26/07/2000 06:48:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00396959
Message ID:
00396961
Vues:
7
Hi Kev,

The DCT file is the memo (FPT) file for your database container (DBC). All VFP metadata are kept in renamed (and sometimes slightly modified) standard VFP tables. For database containers (DBC), the equivilent files are
DBC --> DBF
DCX --> CDX
DCT --> FPT
The reason your file size has blown out is "memo bloat". Whenever you make a change to any elemnt of a datbase, the record for that file is deleted and a new one inserted in its place. Many of the records in the DBC have one or more memo fields with lots of data in them. Making a change to that row copies all the memo field data as well.

The good news is that you can reduce the file size again by doing a pack on the database.

Cheers,

Andrew Coates




>Can someone tell what the DCT file contains and why it perhaps growed on my test system from around 300K to 14MB?
>
>Thanks
>Kev


If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?


From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."


All my FoxTalk and other articles are available on my web site.


Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform