From: | Andreas Prohaska <ap(at)apeiron(dot)de> |
---|---|
To: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Streaming binary data into db, difference between Blob |
Date: | 2003-09-10 14:02:56 |
Message-ID: | A11D9B8C48C1D411AE0C000062A129947B1C65@ganymed.allocation.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> I was following the conversation on blobs with interest.
>
> c-jdbc supports Blobs and Binaries with Postgres.
> At the moment though, given the number of different platforms we are
> trying to support there is no streaming as such available.
>
Well, my Blobs aren't that large and if using c-jdbc comes with this
price, I'll have to live with it. It's just that I want to keep this
low memory footprint as long as possible.
I need Blobs in a Java Servlet application and as long as 1 user
uploads/downloads a 5MB blob I don't care. However if 50 people
upload/download 5MB blobs at the same time, buffers will grow to
250MB only for passing data from the db through to the client.
>From a theoretical point of view that's ridiculous.
I don't expect this to happen, though. In case I get
OutOfMemoryExceptions I will simply turn off c-jdbc again.
Anyway, both Postgres and c-jdbc are great :-)
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Nasser | 2003-09-10 14:04:30 | Re: Streaming binary data into db, difference between |
Previous Message | Nicolas Modrzyk | 2003-09-10 13:48:52 | Re: Streaming binary data into db, difference between Blob |