Ways to increase performance of a Softr website (and underlying database)?

Ask the community
6

Dear community,

And some more possibilities for (big) improvement of both loading times AND user experience are:

  1. Allow Softr list blocks to connect to more than just 1 table. Conditional filters can easily help to filter/present the right data.

  2. As long as point 1 is not resolved, opting for a less efficient database design perhaps makes Softr’s life easier loading (and filtering) this data. By less efficient I mean more rows that can be read by Softr as different records (instead of columns that can’t be interpreted/presented by Softr as records). I suspect that the sum of a lesser efficient database design combined with easier loading by Softr may overall improve the performance of my website. I will test this later (and update this thread).

Example of my use case: I have a table ‘projects’ in my database that shows various user-specific data in many columns on ONE row per project (efficient database design, considering the limitations of Airtable/Smartsuite that neither of them can combine multiple tables without automations ensuring endless linking), but this requires multiple blocks with filters in Softr (as Softr is unable to connect list blocks to more than one table (point 1 above) resulting in inefficient data loading/filtering with Softr).

  1. Add a grouping functionality to list-blocks. A request was already made here: List / Table view - Grouping records - Ask the community - Softr Community - This can seriously reduce loading times (and make the website look SO MUCH better).
1 Like