db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Enyedi <robert.eny...@intland.com>
Subject Re: Large BLOBs
Date Fri, 08 Sep 2006 14:08:52 GMT
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
>>     
>
>
>
>   


Mime
View raw message