The way you show is definitely the wrong approach, as it'll read the entire
table. Try:
http://cwiki.apache.org/confluence/display/CAYDOC/Customizing+Queries
Look at the "Indirect Queries" section at the bottom. That approach would
be much faster.
/dev/mrg
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:17:41 EDT