hm - I would prefer a sollution like wet wired mentioned...
xenon - your hack is great, but I have to convert 'bout 600.000 posts and this would last a long time.
I have no problem with database-space - my problem is the big search index.
an db-archive feature could be like:
- seperate archive -forum / -thread / -post / -attachement / -poll / -pollvote / -searchindex tabels
- moving threads form live to archive and back
- no posting in archive threads possible
- parameters for "makearchive.php" to be accessable via cron
advantage:
- moving threads form live to archive could be done very quickly
- archived thread use still the same fast engine for display
- search index is splitted and therefore each is much smaller
- t.b.c.
hm - can you follow me?
scott
|