Re: ObjectCache

2017-02-24 Thread Markus Reich
I think if you start a "standard" query it goes always against the DB, this would be the query cache but this is not implicit done, you have to use groups for that. Object cache as I understand works behind the scenes, when you access properties of you persistent entity with getters, then values wh

Re: ObjectCache

2017-02-24 Thread Musall, Maik
Hi Lon, so with a context-local cache, you would still execute a regular query, but that query would not actually hit the database but the cache would return the result instead? Is it like a result set per query SQL string which is cached? I don't really understand how those local caches are ke

Re: ObjectCache

2017-02-24 Thread Lon Varscsak
I built something similar in EOF to local cache, so I think I can answer at least part of the question. It’s not uncommon for me to have a complex set of queries to do something like compute pricing on an order. Rather than having to maintain many tiny caches or ivars with query results, all of m

Re: ObjectCache

2017-02-24 Thread Musall, Maik
Hi all, I'd like to extend this question a bit. I just read the entire performance tuning chapter again [1], and I'm a bit puzzled especially about the ObjectContext's local caches, which Andrus also recommended to use in the "A way to refreshObject()" thread: > So instead of micro-optimizatio