Full Version: 0 views but 2 replies? Bug or feature?
...
Aah, so it's a feature!
QUOTE(Gupt @ Jul 19 2006, 02:45 PM) 
Aah, so it's a feature!
a feature: a bug with senority
:-p. I was able to get the speed on the site I think a little better today. I am still looking for root cause fixes 
.
.
That's easy..... the root cause is the number of people who post all kinds of crap trying to get their oh-so-precious little red hearts. I'd hate to see the size of the MySQL database for this site. Even the indexes have to be ungodly. Add to that the number of images people use here, the timelines, etc, and I wouldn't be surprised if the database for this board was in the 1-2 GB range. Without some serious optimization (and a SERIOUS server), it's gonna be slow and buggy at times.
yep. The dB on the old forums was 1-2 GB. In 6 months the new forums has a "posts" table of about 450MB.... Yikes!
Does this mean we are going to have to remove pics and avatars and such?
I'd suggest that the OFF-TOPIC forum is the biggest culprit and that perhaps you should instigate a time-limit for keeping off-topic posts (like say 12 months old, or 50 pages of posts, whichever comes sooner.) People might need to search for old on-topic postings but I honestly can't see ANY use in keeping aged jokes and chit-chat...
Well with the new server things are smooth again. =) So for now we are good...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.