cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack O'Connor <>
Subject counting rows
Date Mon, 23 Jul 2007 10:49:56 GMT
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?


View raw message