Re: slug permalinks can lead to db problems
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.
: 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);