Solved: Fastest Way to Create Large Number of Rows - Page 2

Ed_Cottrell · 10-12-2022 10:18 PM

I'm looking to build a functionality that will create (for example) 700 rows upon execution across 7 tables (Grandparent, parents, children). These are my options:

A single grouped action that creates all 700 rows on the device, which then will take a very very long time to save to server (very bad UX)
A single action that triggers a BOT to create the 700 rows on server, and sync with asynch mode OFF, such that the sync will not complete until the 700 rows are all created and ready to be sent to the device (long sync time, depending on how long the BOT takes to run)
BOT with asynch mode ON, such that the BOT runs in the background (result not visible until some time later and user manually syncs)
BOT to send webhook to Appsheet API (I suspect same time taken as BOT but not sure)
BOT to send webhook to our third party webapp to insert the rows, and return when complete to allow sync to finish. This option we have some control over speed with multi-threading, and virtual machine configuration etc.
Create some triggers on our MySQL DB to insert the rows (as actually all variables in the new rows can be calculated from other tables)

Any other ideas, and in particular experience out there as to how to create such a large number or rows as quickly as possible with good UX?

@MultiTech @Aleksi @Bellave_Jayaram

Aleksi

The best option is to use AppSheet API as it's happening on the server side. Adding 700 rows takes probably 10+ secs (actually it will take the same even with 7000 rows) as they will be created as a bulk. BUT.. if you have even one virtual column in your table, that will ruin this as it needs to be calculated row by row and throws a timeout error. What I have used in a case like this.. create a dummy app for the same data source as you can trigger the API in another app with the Bot. In this AppB you don't need to have those virtual columns as it is just for the filling purpose.

View solution in original post