Subject Re: Blob Performance hints?
Author Roman Rokytskyy
Hi,

> I'm working on a servlet that stores and reads blobs from Firebird
> using Jaybird. All is working OK, except the speed of retrieving
> the blobs seems very slow compared to a write.
>
> Anybody have any hints on how to improve performance?

What exactly throughput you get? I would expect something around
~2-2.5 MB/s on big chunks of data.

> Should Iincrease the initial size of the byte array and/or match it
> to multiples of the block size of the blob's database?

Should not be an issue. FBBlob uses BufferedInputStream with buffer
length you specify in connection params.

Check if ResultSet.getBytes(int) works faster (only as a test).

Regards,
Roman