It will always be faster for the database to return count(*) than to
fetch all records and count them yourself.
However, if you're going to load those objects into memory anyway, it
may be faster for your application in the long run to fetch them all
up front.
On 6/1/07, Peter Schröder <[EMAIL PROTECTED]> wrote:
hi,
i am wondering about the perfomance-impact of using cayenne to performing an
result-count.
currently i am doing something like this, wich is very straight-forward.
SelectQuery query = new SelectQuery(Tcomrecherche.class,
qualifier);
List list = context.performQuery(query);
return list.size();
i could also use an SQLTemplate or a named query to perform a COUNT(*) which
would be much uglier. i would prefer the first solution, but i think that this
operation will take much more work for mysql-db than the direct query.
are there some hints on how to handle this?
kind regards,
peter
