Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CDX bloat
Message
 
 
À
27/03/2015 15:21:04
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:
01617340
Vues:
79
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.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform