Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CDX bloat
Message
De
27/03/2015 15:21:04
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
CDX bloat
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:
01617333
Vues:
60
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform