Query caching latency expectations

💬 Queries and Resources
,
1

I have a salesforce query with caching enabled with no data transformation and no event handlers. When there is a cache hit, I’m seeing a range of latencies / execution times for it: eg 500 ms, 2 seconds, etc. 2 questions:

  1. Why it would take 2 seconds to execute, when the cache is hit. The uncached query is around 600 ms, sometimes a little more.
  2. Is there a general expectation of what a cache hit “should” take?

Thanks,

Larry

1 Like
4

Hi @lkiss,

That is very odd that cached hits are taking that much time :head_shaking_vertically:

I would expect caching to make the response faster.

Are you able to share any screenshots of your query to rule out any in app variables?

I can check with our engineers on our Redis services for caching to see if we can figure out what could be effecting this.

Also what would be super helpful is if you could record the network activity and send us a HAR file :folded_hands:or request IDs on the query runs that have outlier times.