Derby uses only as much space as the size of your BLOB. The DDL for size of BLOB column is the maximum BLOB you can store.
On 5 December 2014 at 06:57, kosurusekhar <[email protected]> wrote: > Thanks Mike for quick reply. > > > 2) whether derby will occupy complete 6MB space if I am trying to insert > > small size files like 512KB or 1MB? > *space used will be that of the size of the inserted column plus some > metadata overhead/page overhead. * > > This means that in a 6MB column if I save 512KB content file then it will > occupy 6MB + metadata size. Right? > > Is there any provision to space in this kind of scenario ? > > > Thanks > Sekhar. > > > > -- > View this message in context: > http://apache-database.10148.n7.nabble.com/Blob-column-behaviour-when-we-dont-have-data-when-having-less-data-tp143363p143376.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. > -- Peter Ondruška
