How can I configure my MySQL database to intake records at lightning speed?

[MultiTech]

Hey all you MySQL masters out there, I have a question for you.

I’ve seen an app integrated with a MySQL database upload records to the cloud in crazy speed; literally as fast as you can read 1, 2, 3, 4, 5 they’re gone!

I have successfully migrated things over to a MySQL db, utilizing the Copy App feature of AppSheet so they create all the tables etc. The speed of the syncs has not changed, not in any significant way.

What can I do to configure my MySQL instance so it has that crazy fast record acceptance?

Thanks a bunch!!!
(^_^)

[David_Joyce]

You say the sync times have not changed. At all? Because if the bottleneck is between the app and AppSheet servers I wouldnt expect the sync times to change. I also have migrated an app from gsheets to mysql and I didnt notice any changes.
I checked my security filters, but according to the appsheet performance analysis the delays are in formatting rule expressions.

However, you can tak a look at this post, may be useful to you

Improving performance by getting rid of unnecessary virtual columns Questions

If you are using a Ref field and you don’t change that column type, it will regenerate the virtual list column after saving.