General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
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