The first step is to remove unnecessary data in the table/worksheet itself. In reality, this may not be a choice you have because your data set may already reside in a specific data provider.
#Box sync slow download
With Office365, spreadsheet formulas can be run in the cloud by Office365, whereas with Dropbox and Box AppSheet has to download the entire Excel file and evaluate formulas locally. If using Excel, it is more efficient to use Office365 than a pure file system like Dropbox or Box.Among spreadsheet file systems, Google Sheets is the most performant as it has been built from the ground-up to support web-based concurrent data access.Database providers are generally better than file system or spreadsheet providers.All the data providers vary in terms of the initial latency in responding to a request. Choose an efficient data providerĪppSheet supports many different data providers. The AppSheet platform provides tools (like the Performance Profile) for you to understand, analyze, and improve app performance. Run Sync in the background so that the user is not waiting for a Sync to occur.Use a faster network (this is relevant for the connection between the device and the AppSheet Server).Fetch or compute data in parallel (relevant if there are many tables in the app or many expensive virtual columns).Reduce the amount of computation (for spreadsheet formulas and virtual columns) performed during Sync.Reduce the amount of data transferred during Sync.To improve the speed and performance of Sync, consider the following methods: There are additional approaches to improve the speed of Syncs that involve data updates, as described in Improve the speed of Sync with data updates. In this article, we'll focus on read-only Syncs as this affects all apps. If you can focus on improving Sync performance, it will have the greatest positive impact on the end-users of the app. Make sure to read and understand the core concepts affecting app performance.
0 kommentar(er)
