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 <Peter.Schroede..reenet-ag.de> 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
>
This archive was generated by hypermail 2.0.0 : Fri Jun 01 2007 - 10:16:03 EDT