Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting data in a blob field
Message
From
17/05/2005 17:32:37
 
 
To
17/05/2005 15:07:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01014882
Message ID:
01015115
Views:
23
>>>Hi Sergey. Whats the difference between blob and binary memo field in VFP9? Seems the same to me?
>>
>>Besides Sergey's answer, a BLOB field nicely solves the problem of storing images (or other binary data) in a DBF, avoiding the dreaded MEMO GENERAL fields.
>
>But presumably not avoiding memo file bloat :) Havent had a chance to play with it yet :)



Nope. Memo's by definition work on blocks. They reserve the block size even if you pass the size by one byte, a whole new block is spent. Then when you delete a record and re-change it, a new set of memo blocks are reserved, therefore bloat. But you already knew this. Memo bloat has not changed. What has changed is that with BLOBs, which resolve to text, you get to use regular memos not General, which bloat rate is insane.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform