View Single Post
Old January 6th, 2008, 21:07   #120
tgrayson
Old Skool
 
Join Date: Sep 2006
Location: Memphis, TN
Posts: 2,106
Default Re: Slow page loads and Posts

Quote:
Originally Posted by Kristie View Post
but anyways, it might come down to having to prune the forum and getting rid of a few years worth of threads. I kinda wonder what would happen, if anything, if we did that... would it even be worth it?
I work with databases. At work, we have some that hundreds of millions of rows. Very slow! The larger the database, the slower the queries, unless you run some massively parallel system, such as Google. Any database of any size simply must archive old data.

Do you know how big your databases are? Are all threads stored in one table? Very active areas such as "General" should be purged, perhaps placed into a table all its own. There are other ways to speed up databases, but I would suppose that if your databases are configured by vBulletin, they would be fairly optimal.
__________________
Core Concepts of Flight

If an error is corrected whenever it is recognized as such, the path of error is the path of truth

--Hans Reichenback
tgrayson is online now   Reply With Quote