Re: Problems with caching

From: Marcin Skladaniec (marci..sh.com.au)
Date: Thu Feb 09 2006 - 19:29:25 EST

  • Next message: Andrus Adamchik: "Re: New Doc space"

    Oh yes, now I see it. Maybe I should start to drink coffee before
    posting to the list ...
    Thank you
    Marcin
    On 10/02/2006, at 10:09 AM, Andrus Adamchik wrote:

    >
    > On Feb 9, 2006, at 4:46 PM, Marcin Skladaniec wrote:
    >
    >> I can understand why caching is supporting only queries with name,
    >> but wouldn't it be good if all queries were cached?
    >
    > There is a difference between caching objects by ObjectId and
    > caching query results that are lists of objects.
    >
    > When you send an ad hoc query, you don't know what rows in the db
    > it is going to match, and there is certainly no guarantee that all
    > of them are already in memory. And even if there was, Cayenne is a
    > not a database to do extensive in memory queries. The last point is
    > the most important IMO - Cayenne != RDBMS.
    >
    > So we only support caching of individual objects and those queries
    > that the user explicitly tells us to.
    >
    > Andrus



    This archive was generated by hypermail 2.0.0 : Thu Feb 09 2006 - 19:29:28 EST