search

rails / solid_cable

A database backed ActionCable adapter
MIT License
121 stars 7 forks source link

Consider using a channel_hash column and index #13

Closed djmb closed 1 week ago

djmb commented 1 week ago

Solid Cable is using 500 bytes for the channel in the index. By generating a channel_hash column and indexing that instead we could have a much more compact index. WDYT @npezza93?

In Solid Cache we use an 8 byte integer generated from the start of a Digest::SHA256.digest.

npezza93 commented 1 week ago

Sweet! Thanks for this @djmb. Opened up #14 to address this.