db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yves piel <yvesp...@free.fr>
Subject [SELECT][RESULTSET] How Derby deals with very large select ?
Date Thu, 30 Mar 2006 08:22:15 GMT
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


Mime
View raw message