cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Kienenberger" <mkien...@gmail.com>
Subject Re: performing count
Date Fri, 01 Jun 2007 14:15:34 GMT
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.Schroeder@freenet-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
>

Mime
View raw message