Sekhar, you asked, "This means that in a 6MB column if I save 512KB content file then it will occupy 6MB + metadata size. Right?". I think the answer is no. The size will be 512KB+metadata size. Mike, please correct me if I am wrong.
On Thu, Dec 4, 2014 at 10:10 PM, Peter Ondruška <[email protected]> wrote: > 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 >
