I'm trying to speed up a customized version of the Pal index thingy, and am noticing that the portion that takes the most time to generate is the top 10 posters. I slimmed it down as best as i could and even added a variable to set where you can set the number of posts to cut off (in hopes that the added WHERE clause may speed it up), but sadly it didn't boost the performace considerably (only a .002 gain in speed)
So, tinkering around, i added an index on the U_Totalposts and the time to generate went from .113 to .003
Will this hamper the forum in any way? I image it may slow down the adding of a new post process slightly, but on what level i'm unsure of.
I appreciate any feedback you can offer, TIA!
