db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject reading a blob column seems slow
Date Tue, 19 Sep 2006 09:57:42 GMT

I have a table that has a blob column. When the select statement 
includes that column it runs much slower than if it is not included, and 
this seems quite a bit slower than for other databases (oracle, mysql, 
The time taken seems to be when reading the blob from the ResultSet.
Is there any recommended way to read from a blob (to get a String) so as 
to maximise performance? I'm using derby.storage.pageSize=32768, but 
otherwise than that default values.


View raw message