Re: performing count

From: Michael Gentry (blacknex..mail.com)
Date: Fri Jun 01 2007 - 10:17:06 EDT

  • Next message: Peter Schröder: "AW: 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 <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