Are there any tricks to optimizing loading from SQL cache In

Question

Are there any tricks to optimizing loading from SQL cache In debug loading from the cache is very slow ~2 seconds for a list of 20 objects Faster in release of course but I have a feeling something can be done Do you see visible delays when loading data from cache

wasyl · Answer

Sample flame chart just for reference The left hand `selectRecordForKey` is ~500ms

taso · Answer

In my old company we were using it but we were loading quite a big query And it was always slow Since it is in background we didn t mind that much

wasyl · Answer

same call

wasyl · Answer

< taso> Thanks It s in background but if it s rather slow I m thinking if we need to preload it before user actually opens the screen otherwise they see loading indicator even though the data should be there confused I wanted to check if perhaps I can speed things up without that overhead first slightly smiling face

mbonnin · Answer

For what it s worth I m looking into this for 3 0 <https github com apollographql apollo android pull 2863>

mbonnin · Answer

That should speed up the process by a few percent but I don t expect an order of magnitude of improvement given that most of the time is spent executing the SQL queries

mbonnin · Answer

Another thing we could do is batch SQL queries It s not super easy though because we don t know the cache ids in advance so we d have to do something like breadth first traverse the model tree run all SQL queries and then reconstruct the tree

wasyl · Answer

Thanks slightly smiling face The batching queries is interesting I understand it wouldn t be any simpler for lists either I m curious about the `readList` that s taking a big chunk of time on the second graph it seems to be the slowest bit

mbonnin · Answer

Reading all cache references in a list can actually be parallelize relatively easily I think

mbonnin · Answer

The relative is compared to parallelizing references in objects

mbonnin · Answer

Overall the whole thing is not straightfoward and there s a bunch of cleanup that needs to happen first

wasyl · Answer

Got it I don t have much spare time but if at any point there s a clear direction how this can happen I could try implementing it slightly smiling face