db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruška <peter.ondru...@kaibo.eu>
Subject Re: Blob column behaviour, when we dont have data & when having less data
Date Fri, 05 Dec 2014 06:10:58 GMT
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 <kosurusekhar@gmail.com> 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

Mime
View raw message