How to do an archive forum to save CPU load? - 06/15/2003 10:55 AM
I would like to only leave a few thousand posts on the forum, all others could go to another "archive" forum. I suspect this reduces server load. Most people only read yesterday's posts anyway, so why carry 200 000 posts?
It does not look difficult, it just is not quite trivial.
I thought about doing the following
copy the database, running a copy of the forum with the copy. disable posting for all people on the archive board.
then deleting most posts on the original databasef
A few problems:
a) what happens to new users, they are not in the archive database, so they don't have read permission in the archive
b)how can I update the archive 2 weeks later at the next archiving opportunity?? It seems easier to do the original 1st archive than to update later.
Maybe we can even automatically always update every day the archive to keep it current.
I think this should be a feature in the official threads distribution. Instead of deleting old messages, move them to archive!!
This is urgent because the other option is to buy a new bigger server!!!!! I need to greatly reduce load!!!!!
It does not look difficult, it just is not quite trivial.
I thought about doing the following
copy the database, running a copy of the forum with the copy. disable posting for all people on the archive board.
then deleting most posts on the original databasef
A few problems:
a) what happens to new users, they are not in the archive database, so they don't have read permission in the archive
b)how can I update the archive 2 weeks later at the next archiving opportunity?? It seems easier to do the original 1st archive than to update later.
Maybe we can even automatically always update every day the archive to keep it current.
I think this should be a feature in the official threads distribution. Instead of deleting old messages, move them to archive!!
This is urgent because the other option is to buy a new bigger server!!!!! I need to greatly reduce load!!!!!