Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 73099 invoked from network); 30 Mar 2006 08:28:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Mar 2006 08:28:55 -0000 Received: (qmail 55395 invoked by uid 500); 30 Mar 2006 08:28:54 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 55365 invoked by uid 500); 30 Mar 2006 08:28:54 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 36485 invoked by uid 99); 30 Mar 2006 08:19:45 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Subject: [SELECT][RESULTSET] How Derby deals with very large select ? From: yves piel To: Derby Discussion Content-Type: text/plain Date: Thu, 30 Mar 2006 10:22:15 +0200 Message-Id: <1143706935.6786.12.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello, I have a table with more than 1,000,000 records. I have to iterate over all records (from the first to the last) very quicly. What is the best way ? Is I do a naive 'select * from data' how long the ResultSet would be created (30 seconds is the mx that I can spend) ? My table is defined like this : CREATE TABLE data ( typecarnet VARCHAR(100) NOT NULL, instance INTEGER NOT NULL, numvign INTEGER NOT NULL, data BLOB NOT NULL PRIMARY KEY (typecarnet, instance, numvign) ) best regards, -- yves piel