MyBB Community Forums

Full Version: mybb_threadsrating without index
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I noticed today that the threadsrating table is not indexed. Is that going to make a less optimal search when a rating occurs and it checks the table for a duplicate? Or how about when the forumdisplay loads and it checks ratings to see if the member rated the thread. I always have a ton of full table searches that are not optimized using indexes and I could never find out where. I think I just did.
You might notice a small improvement if you added indexes but that table will probably be pretty small always.
Nevermind. It is indexed. My phpmyadmin has the details under a hidden div that needed to be expanded. My bad.