eksopl/fuuka — Issue #20: Fix slow queries for thread listing
Author: eksopl
Created: 2012-03-03 11:47:53+00:00
State: open
Labels: DB CHANGE, Defect, Web UI

Unfortunately, the query change by FoOlRulez/FoOlFuuka for ghost mode listing that allowed me to drop the horrible hack that the `*_local` boards were is too heavily dependent on query cache, and it doesn't really scale. Matters are made worse by utf8mb4, which apparently trashes the cache a little bit more? (perhaps using BLOB fields is a better approach, considering we don't really need MySQL to know about what kind of data it's storing for us, as long as one is using Sphinx).

Instead of just delaying the inevitable, fix this issue by introducing a table that lists threads, along with useful data for them, which will allow simplifying the queries for thread listing by quite a lot.