go-ssb-room
go-ssb-room copied to clipboard
SQLite indexes
Before I forget this again: SQLite doesn't index anything by hand, not even foreign key relations.
In general we need to add these for all the columns we query on:
CREATE [UNIQUE] INDEX index_name
ON table_name(column_list);
See also: https://sqlite.org/lang_createindex.html
- [x] Aliases
- [x] Members
- [x] AuthFallBack
- [x] AuthWithSSB
- [x] Invites
- [ ] Notices
- [ ] Pinned
(updated after #91)