Is there a way to seed an apps data by requesting user input via prompt/form, prior to loading, and then passing that to a where clause in SQL?
Example - If I have a long sync time, or a dataset of 1 million rows (ex. sku lookup)…what is the best way to only get the necessary data in the app?
Has anyone partitioned on SQL?
I am doing an apples to apples comparison of a 17k 15 column dataset…google sheet vs. aws sql…
- google sheet is 17 seconds sync time
- sql is 29 seconds
both of these are wide open with no security filters.