db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: A fast row count with DatabaseMetaData.getIndexInfo() / tableIndexStatistic / CARDINALITY?
Date Sat, 03 May 2008 15:43:10 GMT
> - any alternate way of achieving my goal of a fast row count 

How accurate does your count need to be? One idea would be to
set up some sort of periodic background task which computes
the current sizes of your tables and stores that information in
another table in your database.

Then, when you needed the count, you could simply read it
from your stored-counts table.

You could adjust the frequency of the background task to
improve the accuracy of the count.

thanks,

bryan


Mime
View raw message