go-ssb-room icon indicating copy to clipboard operation
go-ssb-room copied to clipboard

SQLite indexes

Open cryptix opened this issue 3 years ago • 0 comments

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)

cryptix avatar Mar 03 '21 09:03 cryptix