What is the recommended way of generating indexes on table columns?

Technical Help
1

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

If you are self-hosting, what version of Baserow are you running?

We are currently at 1.31.0

If you are self-hosting, which installation method do you use to run Baserow?

Docker container

What are the exact steps to reproduce this issue?

We would like to optimize the queries we run via our web app backend to our self-hosted Baserow database.

One way this can be done traditionally in databases is to generate indexes of table columns that are typically used in queries to filter or sort the results.

Therefor our question:
What is the recommended approach to generate table column indexes in a self-hosted Baserow instance?

Thanks in advance,
Kind regards,

Stijn De Vos

2

Hi!

Baserow already adds indexes to tables it manages, mostly for searching and sorting. They should improve performance in most of the cases. Do you have any specific performance problems when using Baserow?

What is the recommended approach to generate table column indexes in a self-hosted Baserow instance?

There is no recommended way, as you should not interfere with tables managed by Baserow. You can add indexes manually in the database, but then you should really know what and why you’re doing. Also, do a backup first.