db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudg...@informaticsmatters.com>
Subject Re: Slow performance of select count(*) from a_table
Date Thu, 09 Oct 2008 10:32:46 GMT
Knut Anders Hatlen wrote:
> Tim Dudgeon <tdudgeon@informaticsmatters.com> writes:
> 
>> 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?
> 
> Hi Tim,
> 
> I think that's how count(*) is implemented currently.
> 

So can this be optimised?
Should I submit a RFE?

Thanks

Tim


Mime
View raw message