db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: Blob column behaviour, when we dont have data & when having less data
Date Fri, 05 Dec 2014 06:21:59 GMT
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 <peter.ondruska@kaibo.eu>
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 <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