performing count

From: Peter Schröder (Peter.Schroede..reenet-ag.de)
Date: Fri Jun 01 2007 - 10:06:15 EDT

  • Next message: Mike Kienenberger: "Re: performing count"

    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:06:21 EDT