That’s cause you’re not actually the database tables. You’re only hitting the index. ;-)


Kinda fun, aint it?


From: Nurullah Akkaya [mailto:nurullah_akkaya@yahoo.com]
Sent: Tuesday, February 06, 2007 4:52 PM
To: Derby Discussion
Subject: Re: keeping the table ordered


for who ever searches these archives creating a composite index that includes all the columns i query solved the problem. i can read 2.7 million records in 11 seconds another query that selects around 800k records dropped to about 4 secs.