Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What causes memo bloat?
Message
From
30/07/1999 14:28:18
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00248272
Message ID:
00248298
Views:
12
>I'm planning an app that will log support issues. Each phone call would start an incident, and all information pertaining to that issue should be stored together. My first thought was to use memo fields to allow the support person to log in all the information. However, I've heard a lot of talk about memo bloat, which makes me think twice. Is this a situation where memo bloat might occur? Is it that severe of an issue? Thanks for your help.
>
>Marcus.

Memos pre-allocate space in blocks (see SET BLOCKSIZE). If you have a memo that completely fills the block, it then allocates CurrentBlocks + 1 blocks and copies the entire memo for that record to the new space. The old block(s) aren't released to be reused. PACK MEMO as part of your maintenance routine will help.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform