Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange Table bloat
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00769319
Message ID:
00769321
Views:
25
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
Previous
Reply
Map
View

Click here to load this message in the networking platform