db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject Slow performance of select count(*) from a_table
Date Sun, 05 Oct 2008 20:01:51 GMT
I have a large table (24 million rows) and getting the row count with 
select count(*) from a_table is taking about 50 seconds.
This seems surprising to me. Surely Derby is not going through every row 
and counting them?


View raw message