db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mike matrigali <mikema...@gmail.com>
Subject Re: Blob column behaviour, when we dont have data & when having less data
Date Fri, 05 Dec 2014 19:42:50 GMT
On 12/4/2014 9:57 PM, kosurusekhar 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?
>
no, it will be 512kb plus a relatively small overhead.

> 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.
> .
>


Mime
View raw message