Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo Bloat during update routine...
Message
From
30/11/1999 19:46:05
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00296936
Message ID:
00297186
Views:
40
>Ed,
>
>>Nope - VFP does not reuse blocks in a memo field when the field is updated, so each REPLACE is expensive - it create new blocks to write the entire field content fresh each time you update it.
>
>This isn't true. VFP will reuse the allocation if the content still fits. There is a bug in VFP5 which prevents memo reuse but it was fixed in VFP6.

In my testing, it only reuses for a replace, not update and not through ODBC. And only when exclusive use is on. Have you seen different results?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform