This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello,
I want to make an App with Appsheet with a MySql BDD.
My problem is that I have to work with a table that contains more than 600,000 lines.
I only need to work with 5% of that data, but I don’t know how to filter that table. How can I filter the data of that “super table”? … the synchronization is now very very slow and that is why I cannot do the App.
There are several possible solutions. Will the way that you filter it remain constant? Will you just be reading this table or will you need to write to it?
If you just need to read it and the filtering will remain constant, then create a view within your database and then just import that view into the app as a table.
If you need to write to the table, use the security filter option for that table. The security filter will work directly on the database and result in just getting the data requested.
Don’t use the slice option for this because it will download all of the data still and then slice it.
LinkedIn
Twitter
