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
