Huge sync time due to GoogleRowValues_GetRowNumbersForAppend

[Mrak123]

Hi all,

Been having some ongoing issues with sync speed, have tried numerous fixes, but latest attempt has involved deep diving the performance analyzer.

Is anyone able to give advice on what might be causing big sync times for these parts (as shown in analyzer):

[internal] DataLayer_AppendTableRows

- [internal] DataLayer_CreateLockWait

[internal] GoogleRowValues_GetRowNumbersForAppend  

Some of these sections are currently taking over a minute per update, compared to a mere few seconds before

[rmsmeltz]

@Mrak123 

It sounds like you are experiencing slow sync times in your AppSheet app, and the performance analyzer is showing that the [internal] DataLayer_AppendTableRows, [internal] DataLayer_CreateLockWait, and [internal] GoogleRowValues_GetRowNumbersForAppend parts are taking a long time to complete. Here are some possible solutions:

1. Check your network connection and bandwidth to ensure that your device is able to transfer data quickly. Slow network speeds can cause slow sync times and longer loading times for your app. You may also want to try syncing your app from a different network or device to see if the issue is related to your current setup.

2. Check the size of the tables that are being synced to see if they are too large. If a table is too large, it can slow down sync times and cause performance issues. You may need to break up the table into smaller tables or adjust your data model to improve performance.

3. Check your app settings to ensure that your sync options are optimized for performance. For example, you can try enabling the "Use Bulk API" option in the "Data" tab of the app editor to speed up sync times for large tables.

4. If none of the above solutions work, you may need to reach out to the AppSheet support team for further assistance. They can help you diagnose the issue and provide more targeted solutions based on the specifics of your app and data. They may also be able to help you optimize your app's performance and improve sync times.