Re: ObjectCache

2017-03-09 Thread Lon Varscsak
Ah, okay, cool. On Thu, Mar 9, 2017 at 11:16 AM, John Huss wrote: > Yes, but an ObjectSelect will not rely on the snapshot cache - it can't. > > On Thu, Mar 9, 2017 at 11:46 AM Lon Varscsak > wrote: > > > Hmm, are you sure John? I agree that the Objects won’t be in any object > > cache, but wo

Re: ObjectCache

2017-03-09 Thread John Huss
Yes, but an ObjectSelect will not rely on the snapshot cache - it can't. On Thu, Mar 9, 2017 at 11:46 AM Lon Varscsak wrote: > Hmm, are you sure John? I agree that the Objects won’t be in any object > cache, but won’t the data be in the snapshot cache (just like EOF)? > > On Wed, Mar 8, 2017 at

Re: ObjectCache

2017-03-09 Thread Lon Varscsak
Hmm, are you sure John? I agree that the Objects won’t be in any object cache, but won’t the data be in the snapshot cache (just like EOF)? On Wed, Mar 8, 2017 at 2:30 PM, John Huss wrote: > Right > On Wed, Mar 8, 2017 at 3:16 PM Musall, Maik wrote: > > > And unless I'm explictly creating a qu

Re: ObjectCache

2017-03-08 Thread John Huss
Right On Wed, Mar 8, 2017 at 3:16 PM Musall, Maik wrote: > And unless I'm explictly creating a query cache somewhere in my > application, > I won't have one? > > > Am 08.03.2017 um 22:05 schrieb John Huss : > > > > Unless you are using a query cache then running an ObjectSelect will > always > >

Re: ObjectCache

2017-03-08 Thread Musall, Maik
And unless I'm explictly creating a query cache somewhere in my application, I won't have one? > Am 08.03.2017 um 22:05 schrieb John Huss : > > Unless you are using a query cache then running an ObjectSelect will always > give you fresh data from the DB. > On Wed, Mar 8, 2017 at 3:01 PM Musall, M

Re: ObjectCache

2017-03-08 Thread John Huss
Unless you are using a query cache then running an ObjectSelect will always give you fresh data from the DB. On Wed, Mar 8, 2017 at 3:01 PM Musall, Maik wrote: > Can someone confirm this? Will I always get fresh data from DB with an > explicit query, or am I at risk being returned stale data from

Re: ObjectCache

2017-03-08 Thread Musall, Maik
Can someone confirm this? Will I always get fresh data from DB with an explicit query, or am I at risk being returned stale data from a context-local cache that doesn't even see changes that haven been recorded in the shared snapshot cache in the meantime, let alone in the database? I'm still a

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