Basically the subject. I use the Retool database right now but I find the performance is completely random.
For example, I have on my UI a button that when pressed, unhides a container and scrolls down to it. Super basic, and typically it runs within a second or so of pressing the button, but once in a while, like right now, it takes 15 seconds before it does anything.
Same with queries. I have a simple query like this on the Retool database, that returns 5 rows only:
WHERE type LIKE 'rbi' AND status = 'active'
ORDER BY discounted_msf ASC;
Yet it often takes 13-15 seconds to run. You press the button in the UI and it says "running query" at the bottom and counts up to almost 15 seconds. It's not always, but it definitely does happen to the point it feels like the app is frozen if it wasn't for the "running query" on the bottom.
Should I be looking at self hosted perhaps, or my own SQL database to improve performance, or would it basically be the same thing?