Re: Query on a blob table

[V Narayanan]

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.