thx, that is what i've been looking for! -----Ursprüngliche Nachricht----- Von: Michael Gentry [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 1. Juni 2007 16:17 An: [email protected] Betreff: Re: performing count
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 <[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 >
