Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CDX bloat
Message
De
28/03/2015 06:03:21
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01617333
Message ID:
01617343
Vues:
54
Packing should do.

>Deleted records are not removed from any indexes, unless index is filtered with FOR NOT DELETED().
>
>>I have a site that started complaining that their CDX table with at least ten tags, some with multiple fields nears the 2 GB limit after several days of production. A search suggests that this is an issue with dBASE compatible tables. The suggestion is to pack the table and re-index regularly. With 24 hour production much of the week, getting exclusive access to the table is problematic. I currently re-use deleted records, but I've seen references that the tags in the CDX file are orphaned for deleted records and can only be recovered by deleting all tags and re-indexing the table. I only use free tables. System was begun nearly 30 years ago, but DBCs were considered but rejected for some reason. This is an inherited application.
>>
>>Is this correct?
>>
>>What if instead of deleting records, I re-used them by replacing any or all of the fields with new values? Would this adversely affect performance?
>>
>>TIA.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform