How much grows the database with fields BLOB?
Hum… Pretty generic question… If you read the documentation, you’ll see that the field BLOB does not take a lot of hard disk space when empty (around 8 bytes). But if you add some files in your BLOB, it will increase the size of your database for sure. For example, if you put a 200KB bitmap attached to any of your 1000 items (picture field), I would say it will increase your DB of 200 MB.
quote:
Originally posted by clembo
How much grows the database with fields BLOB?
Its always hard not to laugh at this type of question. But I wont. [;)]The literal answer is that the db will grow to between 8 bytes and 2 Giga Bytes per blob. So if you say had 100,000 items each with a 2gig blob, then your database would grown to 200 Terra bytes. So you can see that the question has no sensible answer. The issue is that you did not ask the correct question? What do you need to know, and why? Are you asking if the database compresses data, then no, it does not. I think you need to restate the question, in terms that would give you a meaningfull answer.