>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