My Sidekick data extension’s handler runs in the Shopify sandbox, but the actual data lives on my own backend (a remote API + DB). So each tool call is: sandbox handler → fetch my backend → query/compute → return JSON, all within the ~1 second budget.
Some of my tools are analytics (aggregations over referrals/commissions) that aren’t instant to compute live.
- For those who’ve shipped Sidekick data extensions with a remote backend, does the network round-trip from the sandbox to your API realistically fit inside 1s in production?
- Is precompute + cache (background job storing results, handler just reads them) the standard approach, or are people computing live?
- Roughly what end-to-end latency have you seen from the sandbox, and does it vary by merchant region?
- When a tool occasionally exceeds 1s and gets skipped — is that per-call, or does Sidekick deprioritize the tool for a while afterward?
Trying to decide how much caching infrastructure to build up front. Thanks!