Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSOR Experiencing Memo Bloat
Message
From
15/07/2006 19:24:41
 
 
To
15/07/2006 17:41:48
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01136610
Message ID:
01136727
Views:
11
>I have always relied on the fact that memo bloat does not exist in any cursor or table that is opened exclusively. This issue has made me confirm that many, many times now. I've created a table (and also a cursor) with a single memo field in it. I have then made a tight loop, replacing the contents hundreds of thousands of times with no problem. So either the memo bloat can occur if "foxpro is really busy" (which I find really hard to believe) or there is something else at work here...

One thing that can be at work here is cache (RAM). In your test scenarios the RAM is likely available for a whole lot of megabytes. In your real application, probably also running with other stuff, the cache available for the memo field (whole cursor, really) is likely significantly less.

By the way, I'd say your disappointing result with NOFILTER is related to this.
I'm quite sure that NOFILTER would have lttle or no impact if the cursor was smallish to start with. But once it exceeds the RAM (cache) available for it then it will have to go to disk.

good luck
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform