cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Schröder <Peter.Schroe...@freenet-ag.de>
Subject AW: counting rows
Date Mon, 23 Jul 2007 10:59:02 GMT
hi jack,

search the list on count query. 

-----Urspr√ľngliche Nachricht-----
Von: Jack O'Connor [mailto:jo4185@bristol.ac.uk] 
Gesendet: Montag, 23. Juli 2007 12:50
An: user@cayenne.apache.org
Betreff: counting rows

A question about efficiency: Counting the number of rows in a table.

Currently, I run a select query, then iterate through the rows, 
incrementing a counter. This takes too long. Is there a way to use the 
SQL command:
SELECT count(*) FROM <table>

Or something similar, that quickly returns the number of rows from a 
select query?

Thanks
Jack

Mime
View raw message