search

nextcloud / tables

🍱 Nextcloud tables app
https://apps.nextcloud.com/apps/tables
GNU Affero General Public License v3.0
133 stars 21 forks source link

add table_id index to oc_tables_columns #1078

Closed grnd-alt closed 3 weeks ago

juliushaertl commented 1 month ago

One thing I missed when discussing this earlier, we should still add the indices to the existing migration files where the tables are created. That way the index is immediately there on new installations.

enjeck commented 1 month ago

@grnd-alt @juliushaertl Why are we adding an index?

juliushaertl commented 1 month ago

To improve the performance of database queries that use those columns to filter for entries.