Allowing custom blocks of user supplied information is on the list along with the ability to to configure menu items. Right now I'm only working on getting IIP moved over to templated layout with a control panel setup from the admin section of threads.
One of the things I do need to do is make an archival system so that .threads users can move old threads into a seperate table altogether. Forums with tons of posts will make the index slower to generate as there is just way to much information to wade through. I'm willing to bet that a phpnuke display isn't pulling information from 30,000+ posts or better (depending on layout, 3 or 4 pal boxes may need query the same amount of information for different results) for their index, 3 or 4 times for their blocks.
It would seem that starting around that 30 thousand mark, and based on hardware of course, things start to slow down noticabley. Currently 4.3 uses some table joins to lower the number of queries to the database. With 5.0 I have been able to removed all table joins with the exception of the "who's online" one. I'm also caching the "short stats" information. These changes have greatly increased the speed. I have tested it on a 34,000+ post count database, thanks to msula and compared his site it is over 4 times faster.
caspe7 has a website with over 84,000+ (84292 as of this post) posts. The related page generation info is: Generated in 3.6 seconds. 30 queries. Zlib compression enabled. Here is caspe7's website: http://www.prowrestlingforum.com/threads/ From the looks of it he is using all of the pal boxes too. (16)
It is strange how things vary though.
msula has a website with 36,000+ (36757 as of this post) posts. The related page generation info is: Generated in 5.594 seconds. 22 queries. Zlib compression disabled. Here is msula's website: http://michiganjeepers.com/index.php From the looks of it he is using 2 less pal boxes. (14)
caspe7's site has well over twice as many posts as msula's and yet the page generation times are almost a full 2 seconds faster. (I pull some hair out of my head daily over this stuff)
Once I have IIP's tempate/control panel stuff done I will work on improving the queries used and will probably cache some more box information too.
My long term goal with IIP is to have people say "*nuke what?"
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.
