bbPress.org

That’s a brilliant suggestion… I’ve noticed a weird lag whenever trying to load up a topic, this could be exactly the problem.

Just tested, seems to speed up the query quite a bit, although I’ll have to do some benchmarking to be sure.

[edit]: I just ran this command manually to create the index, I’m not sure if specifying an index length would help or not.

create index ix_name on bb_topics (topic_slug);