Hi guys, I'm encountering new problems in speed recently as my database has grown quite a bit.
I have around 50k records in my database and it will continue to grow in the future.
right now even with indexes, it take between 7s-15s for a simple Query All Records to load with pagination set to 10 items per page, and loading page 1 only.
This is not realistic for my users to have to wait all this time in the frontend before seeing results.
I am currently on the free Xano plan while I complete my beta version.
What can I do to improve this? will this be fixed just by upgrading to a paid plan?
Please help :))