|
|
|
|
Joined: May 2002
Posts: 17
Newbie
|
|
Newbie
Joined: May 2002
Posts: 17 |
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!
|
|
|
|
|
Joined: Mar 2000
Posts: 21,080 Likes: 3
I type like Navaho
|
|
I type like Navaho
Joined: Mar 2000
Posts: 21,080 Likes: 3 |
not sure, it would require some trial and (lots) of errors on my part...  anyone else? 
|
|
|
|
|
Joined: Apr 2002
Posts: 206
Member
|
|
Member
Joined: Apr 2002
Posts: 206 |
yikes.. I'm with Allen on this one.. heh Would take quite a bit of testing. Nice solution though.
|
|
|
|
|
Joined: Feb 2001
Posts: 104
Journeyman
|
|
Journeyman
Joined: Feb 2001
Posts: 104 |
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.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 21,080
Joined: March 2000
|
|
|
Forums63
Topics37,583
Posts293,955
Members13,824
| |
Most Online151,614
Nov 14th, 2025
|
|
Currently Online 696
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 23
|
|
|
|
|
|
