maybe we could just move old threads over to another archive forum. On the same database. But all the new stuff will run on the main forum. Which seems to be 3 times as fast.
So in other words
active main forum 1000 posts
archive forum 200 000 posts.
Question: I have some inkling that this is due to bad inefficient programming. The same purpose could be reached by reprogramming some database requests! or reorganizing the database??
This is postlist in a small forum with 1000 posts
Generated in 0.439 seconds in which 0.281 seconds were spent on a total of 29 queries. Zlib compression enabled.
The following is postlist in a large forum with 150 000 posts.
Generated in 3.513 seconds in which 3.417 seconds were spent on a total of 29 queries. Zlib compression enabled.
1100 posts
Generated in 0.245 seconds in which 0.178 seconds were spent on a total of 30 queries. Zlib compression enabled.
All this makes a little sense. Postlist is slower for large forums. Still, it does not look like this is necessary! After all, the first page of postlist.php is the same size, in the small 1000 post forum or in the 150 000 post forum.
Now it gets interesting!!
Showflat in the small 500 post forum
Generated in 0.102 seconds in which 0.049 seconds were spent on a total of 13 queries. Zlib compression enabled.
showflat in the big 150 000 forum
Generated in 1.168 seconds in which 1.114 seconds were spent on a total of 13 queries. Zlib compression enabled.
I did all this repeatedly, this is not a quirk or accident. Please someone find out why this is so, then maybe we can reorganize the database in some way.
I see no logical need why showflat in a large forum takes 10 times longer than in a small forum!!! What is worse, most action happens in the large forum.
If there is no simple database reorganization trick, then let us just do automatic bulk moving to archive boards on the same database, on the same board.
Note: I already put the default on seeing only 2 days worth of posts, I think this speeds up things considerably!!
There should be some indexing trick, like indexing the day and week of the first and/or last post. Most posts refer to the last 2 day's or last week's posts. So if that were indexed, only last 2 days were searched initially, that would do the trick!!!!!! If we only chose to display the last 2 days, then only that part of the database should be searched!!
Until the settings get changed (display more than 2 days worth of posts!!)
