Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo bloat
Message
From
05/10/2005 16:16:10
 
 
To
05/10/2005 15:56:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01056130
Message ID:
01056473
Views:
30
>Thanks guys - but did I get an answer from all that?
>
>I am sharing the table with the memo field and each user does use the table in a table buffered mode. I am changing and adding only about 1000 records.
>
>So what should I do to elimiate the bloat.
>
>John

Keep the updates as few as possible. Do as much as possible in memory. I have seen code like this
replace cmemo with cmemo+text1
replace cmemo with cmemo+text2
replace cmemo with cmemo+text3
replace cmemo with cmemo+text4
This is creating bloat on demand! Better is
replace cmemo with cmemo+text1+text2+text3
or
lcMemo=cmemo+text1+text2+text3
replace cmemo with lcmemo
Previous
Reply
Map
View

Click here to load this message in the networking platform