Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo Fields
Message
From
19/01/2007 17:13:05
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
19/01/2007 17:01:51
Hong Yew
People Quest
Malaysia
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01187213
Message ID:
01187217
Views:
20
>Hi All
>
>I find that I have to do constant maintenance of FPT files by PACKING. Is there a way to prevent zip file bloat by zipping and unzipping memo field contents on the fly?
>
>Your advice much appreciated. Thanks
>
>Best Regards

Zipping and unzipping would not completely solve the memo bloat problem - data will still have to be re-written to the memo file.

You might consider, as an alternative, having a bunch of files. Your main table would just have the filename.

Any of these options would be too complicated for my taste - I would just do the regular maintenance (pack the tables).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform