2009-11-28, 08:41 PM
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.