General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Memo Bloat during update routine...
I have an app that updates insurance plans. I store some general notes about each plan in a memo field. This field usually contains 7 or 8 small sentences. My problem is that when I populate this information (one sentence at a time) for thousands of plans the memo field bloats to >330 mb. After packing the memo (and 10 minutes) it goes down to 50mb. I'm worried about users running out of disk space. Is there a way to reduce this without stopping in the middle of the routine and doing a pack memo? I update the memo fields with the following code:
REPL myMemo WITH ALLT(myMemo)+CHR(13)+cNewLine IN myTable
I have also used the ADDITIVE reference:
REPL myMemo WITH CHR(13)+cNewLine ADDITIVE IN myTable
This gives no relief to the file size issue.
TIA,
Marcus.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only