LinkedIn
Twitter
My client kept complaining about slow sync speed, and it wasn't showing correctly in the audit log. During a meeting, it took more than a minute to load, but the performance analyzer showed around 20 seconds. On the Asia server, it took less than 10 seconds (as per performance analyzer). I've already raised a support ticket. Here's the difference in sync timing between REAL vs Performance Analyzer.
Hello,
tl;dr thanks for the bug report, yes something happened and we're trying to figure out what. Read on for technical details of why the audit log is misleading you.
The sync duration that shows up in the audit log measures how long the sync takes on the server side. This is usually the right number to benchmark, because it will be relatively consistent across syncs, and we expect the client overhead to stay about the same over time. If you're trying to verify this number with browser tools, you want to measure the `/api/template/{appId}` call and open the timing tab. DOMContentLoaded measures something different. Here's an example sync in one of my apps:
The "waiting for server response" block should be fairly close to the audit log value. Here's the same request for my app.
304ms in the audit log, 740ms in the network tab, so ~440ms for all the network infrastructure in between (not my department). All of this is normal so far.
Once we receive the sync response, the client has to turn that data into a form the app can use. This has always added a significant amount of time to the value in the audit log, and it can be highly variable between client machines. For the sync above, the actual end-to-end sync time (between "hey you got a new template?" and "app is ready to go") is 1742ms. You can't currently get this number as an end user, for largely historical reasons.
The spread between server and client sync started to diverge near the end of October, with a much heavier impact on the slowest apps (95%ile sync time). I'm investigating why.
Thank you for your thorough explanation and for dedicating your time to this matter. Your assistance has been incredibly beneficial. I've been in contact with support since August regarding slower sync especially UK Server, but unfortunately, they've only been sending me generic, pre-written responses without any relevant context.
At least now, I can use your messages to effectively communicate with my clients and address the issues at hand. I've been inundated with messages from various users, and for months, I had no way to respond to them. Your help is greatly appreciated, and I'm eagerly looking forward to resolving this issue as soon as possible.
These emails have not been beneficial for either party, including our clients. At the very least, receiving an acknowledgment from the support team could help address the issue, and we could patiently wait for potential solutions. However, these consistently absurd responses over the past few months are quite concerning. I hope this matter is being addressed internally for a more effective resolution.
It seems that we started experiencing issues around the time when this update was rolled out: AppSheet Sync Performance Improvements - Google Cloud Community
