db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From V Narayanan <V.Naraya...@Sun.COM>
Subject Re: Query on a blob table
Date Tue, 24 Jul 2007 05:18:17 GMT
Hi,


Can you pls mention the derby version you are working with?


Narayanan


Raymond Kroeker wrote:

> Hi All,
>     I have a table encompassing blobs as such:
>
> CREATE TABLE DOCUMENT_VERSION
> (
>    DOCUMENT_ID BIGINT not null,
>    CONTENT BLOB not null,
>    CONTENT_SIZE BIGINT not null,
>    CONTENT_CHECKSUM VARCHAR(256) not null,
>    CHECKSUM_ALGORITHM VARCHAR(16) not null,
>    CONSTRAINT DOCUMENT_VERSION_PK PRIMARY KEY (DOCUMENT_ID)
> );
>
>
>   Now I've loaded 175 rows of 256B blobs and a single row containing a 
> 250MB blob.  When I run the query
>
> select sum(CONTENT_SIZE) from DOCUMENT_VERSION;
>
>   it takes ~10s += 1.5s to complete.  Am I missing something?
>
>   I've tried indexing CONTENT_SIZE (after seeding the data) without 
> any luck.
>
> -- 
> --------------------------------------------------------------------------------
> Raymond Kroeker
> thinkParity Solutions Inc. 


Mime
View raw message