Hello! I asked here a couple of weeks ago whether my apps are really slow because of the number of records in my table. It turns out that is the case, but I have a couple of followup questions.
- Is the decrease in performance related to the number of records size of the base or of the individual tables?
- Is it possible to load a table or base into an app conditionally? And if that is possible, would it even improve the performance of my apps? My experiments so far result in the “too many hooks rendered” error. For ex:
const base = useBase();
let records=null;
let table=null
if(something is true)){
table=base.getTableByNameIfExists('Line Items');
records= useRecords(table)
}
- Any other suggestions for how to improve app performance on large bases/tables? I don’t think I really have the option of deleting records or archiving them in another base because my system of linked records makes it complicated.
Thanks so much!
