Re: BLOB performance test FYI

On 2002-04-18 Joe Shevland wrote:

> > the oid for the LargeObject. The casual user of binary data (which can
> > range from a few bytes to hundreds of megs) should have something out of
> > the box that works symantically as they would expect IMHO.
>
> I totally agree; however as shown the bytea type *will not work* for data
> this size (esp. not hundreds of megs). Both storage and retrieval from the
> client. !!
>
> > I find that
> > many users of bytea are storing gifs and html pages for web sites which
> > generally are small enough such that bytea works fine.
>
> Well, I disagree... even a few kilobytes has shown to be substandard in
> storing.

Some of these problems aren't really about the datatypes themselves, but
how the driver handles them. Instead of streaming large data into the
backend, the client reads them into memory before sending them.
It seems the LO parts of the driver has a different solution, that
streams the data directly.
It would take some major reworking of the JDBC driver to fix this. I've
looked at it, and concluded that it is possible, but that it was too big
for me to fix.

/Anders
--

A n d e r s B e n g t s s o n | ndrsbngtssn(at)yahoo(dot)se
Stockholm, Sweden |

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com