You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Robert Enyedi <ro...@intland.com> on 2006/09/08 09:46:08 UTC

Large BLOBs

We are planning to use Derby for a database that has large BLOB files 
around 50-60 MB. Can Derby handle such large amount of data by default 
or should we think about certain server configuration changes?

Regards,
Robert

Re: Large BLOBs

Posted by Robert Enyedi <ro...@intland.com>.
Andreas,

Thanks for the information. I'll make sure that the max heapsize is 
appropriately set when attempting to load the data.

Regards,
Robert

Andreas Korneliussen wrote:
> Robert Enyedi wrote:
>   
>> We are planning to use Derby for a database that has large BLOB files
>> around 50-60 MB. Can Derby handle such large amount of data by default
>> or should we think about certain server configuration changes?
>>
>>     
>
> By default, derby can handle such large amount of data.
>
> The network client will, when fetching a BLOB, load the entire BLOB into
> memory. The network server, when receiving a BLOB from client, will also
> load it into memory before inserting it into the db. This means that you
> probably need to increase the max heapsize of the VM to avoid
> OutOfMemory errors, or restrict usage to embedded mode.
>
> Regards
> Andreas
>
>   
>> Regards,
>> Robert
>>     
>
>
>
>

Re: Large BLOBs

Posted by Andreas Korneliussen <An...@Sun.COM>.
Robert Enyedi wrote:
> We are planning to use Derby for a database that has large BLOB files
> around 50-60 MB. Can Derby handle such large amount of data by default
> or should we think about certain server configuration changes?
> 

By default, derby can handle such large amount of data.

The network client will, when fetching a BLOB, load the entire BLOB into
memory. The network server, when receiving a BLOB from client, will also
load it into memory before inserting it into the db. This means that you
probably need to increase the max heapsize of the VM to avoid
OutOfMemory errors, or restrict usage to embedded mode.

Regards
Andreas

> Regards,
> Robert