Re: Object not cached/SELECT on each access

2018-01-10 Thread Pascal Robert
> Le 10 janv. 2018 à 11:16, John Huss a écrit : > > Hard to say. > > Is the shared cache enabled? I’m using the default settings. > Is it sized big enough? To hold everything? I don’t think so (+470 000 rows from FileMaker). > > Is the app under memory pressure when this is happening, o

Re: Object not cached/SELECT on each access

2018-01-10 Thread John Huss
Hard to say. Is the shared cache enabled? Is it sized big enough? Is the app under memory pressure when this is happening, or is it happening all the time? On Wed, Jan 10, 2018 at 6:35 AM Pascal Robert wrote: > Hi, > > I’m trying to find out why it takes between 200 and 500 ms to convert an >

Object not cached/SELECT on each access

2018-01-10 Thread Pascal Robert
Hi, I’m trying to find out why it takes between 200 and 500 ms to convert an entity coming from FileMaker and commit the « new » entity to MySQL. Found out that every time I access a property of the fetched object, Cayenne does a SELECT query. Example: try(ResultBatchIterator batch = Objec