Viruses and spam shouldn't affect TFL's performance at all.
The problem with TFL and large vbulletin boards in general is that myisam tables in mysql are terrible. Another view is that vbulletin is improperly designed, since jelsoft should know that virtually everyone uses myisam tables. I'm seriously considering converting the post table to innodb, even though that will make it impossible to use mysql's full-text searching.
Searches for common words are unavoidably slow, which causes a situation described in the second set of bullet points here:
http://dev.mysql.com/doc/refman/5.0/...e-locking.html
__________________
“The egg hatched...” “...the egg hatched... and a hundred baby spiders came out...” (blade runner)
“Who are you?” “A friend. I'm here to prevent you from making a mistake.” “You have no idea what I'm doing here, friend.” “In specific terms, no, but I swore an oath to protect the world...” (continuum)
“It's a goal you won't understand until later. Your job is to make sure he doesn't achieve the goal.” (bsg)
|