Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange Table bloat
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00769319
Message ID:
00769321
Vues:
24
It is a common situation when updating memo field. And it is recommended to /pack memo/ on the regular basis.

>Hi,
>
>We're getting a very strange problem with one of our log files. The table has 9 fields with 1 memo field.
>
>The file acts like an audit log and just keeps track of start and stop events and addition/modification of tables when a custom data import program is running.
>
>The problem is that when the data import program runs, the file seems to grow very fast very quickly within a couple of weeks. The last time this occured, the DBF file was 20Mb and the FPT file was 80Mb with only 44 records. We can browse the table (and memo fields) fine but when we packed the table, the DBF file remained at 20Mb but the FPT was just 20Kb.
>
>We've tried deleting the table and recreating a new one, but this works for only a few days then were back to the same problem.
>
>Any help is greatly appreciated.
>
>Thanks,
>Arriyel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform