search

discord-relay-chat / drc

Discord Relay Chat
https://discordrc.com
MIT License
18 stars 3 forks source link

Use ATTACH DATABASE instead of iterating individual channels #4

Closed edfletcher closed 1 year ago

edfletcher commented 1 year ago

https://www.sqlite.org/lang_attach.html

edfletcher commented 1 year ago

Actually I investigated this, and given that each channel has its own SQLite DB and many searches involve looking across all of those (for a given network at least), this would only increase the query complexity significantly while providing very little benefit (because each DB still needs to be opened). Closing as NTBF.