Topic: Archive
Move the selected topic to the forum archive?
Yes , No.
Every forum has it own archive. cya.
Dan, (Official, i hope :D) PunBBHeb Translator.
1 2003-09-08 17:57 (edited by Wooty 2003-09-08 17:57)
Re: Archive
What would the purpose of this archive be? For every user to store "memorable threads",or something else? Your post was so short :)
-
Re: Archive
Wooty wrote:
Every forum has it own archive. cya.
Uh, what?
"Programming is like sex: one mistake and you have to support it for the rest of your life."
Re: Archive
I think that's part of the feature description. Like you have a bunch of bookmarks in every forum for your favorite threads... or whatever the purpose of this feature is supposed to be :)
-
Re: Archive
I thought he was talking about archiving old posts/threads i.e taking them off the board and putting them into storage so the number of posts didn't grow too large and slow the whole thing down. I think the idea is that the Admin instead of just pruning/deleting old posts moves them to an archive instead.
Re: Archive
thats a dumb feature o.O
Re: Archive
First, this is not a dumb feature.
Secondly - If you have in ur board a forum that is called Guides, you can move good guides (topics) to its archive. and people will check in the archive first.
Dan, (Official, i hope :D) PunBBHeb Translator.
Re: Archive
So, the purpose is like sticky topics, except not sticky?
-
Re: Archive
soo ... it would be like you have made another forum for keeping the archived topics in, nothing more?
Re: Archive
Can't you just move the topic to a special forum of some kind? If you don't want any new posts there, you can just lock the forum.
"Programming is like sex: one mistake and you have to support it for the rest of your life."
Re: Archive
Kennel wrote:
Can't you just move the topic to a special forum of some kind? If you don't want any new posts there, you can just lock the forum.
That makes more sense. I can see a time when this board has grown to the point when it would be useful to have a read only Knowledgebase forum containing instructions on various things, code snippets people have posted etc.
Re: Archive
kennel, i was going to say that XD
Re: Archive
Ok.
Dan, (Official, i hope :D) PunBBHeb Translator.
Re: Archive
o mud none k?
Re: Archive
archive would be a good option
i have a big forum (more than 14.000 users) and a table posts 55Mo
my server crash many times when there are more than 80 users online
archive topic out of table posts and table forum would be great
- Connorhd
- Former PunBB Developer
- Offline
Re: Archive
explain what you mean by archive?
Re: Archive
I need to reduce size of two tables of my database (posts and topics).
So i have create 2 other tables:
- archive_topics => id, subject
- archive_posts => topic_id, poster, message, date
the SELECT with INNER JOIN in the page viewtopic CRASH my server because my forum is too big
then now, no inner join for the archive with these 2 new tables
PS: excuse my bad english
Re: Archive
I have check it. The problem come from user table (more than 15.500 users now). When there's more than 80 users online, MySQL crash.
I search a solution to reduce this table but i don't know how if i want to keep all users ...
Re: Archive
MySQL should never crash due to it being under load. Over at SweClockers.com, we have 2.6 million posts, 262000 topics and 52000 users. During peak hours, we have 2000 users online. MySQL handles this just fine.
"Programming is like sex: one mistake and you have to support it for the rest of your life."
Re: Archive
mysql_stat();
Uptime: 13111
Threads: 20
Questions: 6210748
Slow queries: 1379
Opens: 69319
Flush tables: 1
Open tables: 4095 Queries per second avg: 473.705No crash...
Re: Archive
lebel: Might I ask what the URL of your forums is?
"Programming is like sex: one mistake and you have to support it for the rest of your life."
22 2004-12-21 07:35 (edited by lebel 2004-12-21 07:35)
Re: Archive
hxxx://www.omplanete.com/forum/
23 2004-12-21 07:37 (edited by lebel 2004-12-21 07:40)
Re: Archive
analogue wrote:
mysql_stat();
Uptime: 13111 Threads: 20 Questions: 6210748 Slow queries: 1379 Opens: 69319 Flush tables: 1 Open tables: 4095 Queries per second avg: 473.705No crash...
ouais ok mais tu as combien d'utilisateurs qui se connectent en même temps ?
My website is about football team. When there 's match, 100 users connects to the forum at the same time. And all the time MySQL crash (& the server too)
Re: Archive
lebel: One thing you could try is to convert the online table to the table type MyISAM. You can do this through e.g. phpMyAdmin. I'm not sure it will help, but give it a go.
Nice forum BTW. It should be on PunBBig :)
"Programming is like sex: one mistake and you have to support it for the rest of your life."
Re: Archive
103 on now and still up 