Hey @get-the-memo,
There were several discussions on the forum about Adalo speed optimizations, for instance, this one: Do’s and Don’ts for app speed.
Some general advices from that thread are still useful. However, a lot might depend on the exact app setup, user flow, data size and usage pattern.
In regards to using external collections: this might speed up the app but only sometimes. Many platforms like Supabase or Xano allow to do complex filtered queries on the server side, and return the prepared result to Adalo. Such queries may work faster than when you’re doing it in Adalo Database, especially if you’re aggregating results from different tables with a complex filtered JOINs.
However this comes with a price - you will have to spend much more time setting it up than in Adalo alone.
Best,
Victor.