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)<br /><br />So, tinkering around, i added an index on the U_Totalposts and the time to generate went from .113 to .003<br /><br />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.<br /><br />I appreciate any feedback you can offer, TIA!

not sure, it would require some trial and (lots) of errors on my part... <img src="/forum/images/icons/crazy.gif" alt="" /><br /><br />anyone else? <img src="/forum/images/icons/smile.gif" alt="" />

yikes.. I'm with Allen on this one.. heh <img src="/forum/images/icons/smile.gif" alt="" /> Would take quite a bit of testing. Nice solution though.

What exactly did you add to what, or hey, how do I do that, I'll try it on mine and see what it does.<br /><br />