Re: BYTEA with large files leads to OutOfMemory

On 17/03/2004 15:19 Fuchs Clemens wrote:
> Hi,
>
> I'm working on a project, which has to deal with files being uploaded to
> the
> DB. I created a table using the BYTEA datataype and uploading small files
> works great. But with larger files - I tested with 2.5 MB file - the
> memory
> consumption raises incredibly and leads to a OutOfMemory exception.
>
> I noticed several discussions about this topic, but found no solution.
>
> Can someone help me?

I think you've got 2 options:

1) increase the amount of memory for the JVM

2) use the Large Object interface instead of bytea.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+