You know, I didn't even try to do the poll using all public boards. I just assumed it would be too slow. Prior to v5.0, turning on all of the boxes made the index page have a load time of 40 seconds or so.
I imported about 300,000 posts, 4000 members. I turned on all of the boxes, including pollpal. I have it set to public, and admitedly I have the caches turned up pretty high on some of the boxes (particularly top 10 posters, because we've had a problem with people posting just to see their position move -- if they have to wait a couple hours to see it change it might not be as much fun )
Anyway, with everything turned on the load time is only:
Generated in 3.652 seconds in which 3.58 seconds were spent on a total of 35 queries.
I have it on a test board though, so there is no load (other than me ), but it's still on the same server as our regular board. Is it likely to change when I move it, or can I jump for joy now?
Question -- Under Top Posters, in the editconfig, you say, "Should we cache this information to increase page generation times? " You did mean "decrease", right? Increasing the cache time should decrease the generation time, right?
Also, does the shout box automatically refresh? Where is the time setting for that if 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.