db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raymond Kroeker" <raym...@thinkparity.com>
Subject Query on a blob table
Date Tue, 24 Jul 2007 01:20:35 GMT
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