A solution to keeping database size down?

Anything that doesn't fit anywhere else, and is NON CH related - chat about the weather, or anything else that takes your fancy.

Moderator: Moderators

Katharine
Button Grecian
Posts: 3316
Joined: Mon Dec 26, 2005 10:44 pm
Real Name: Katharine Dobson
Location: Gwynedd

Post by Katharine »

Mid A 15 wrote:I thought it was me when I couldn't access the forum! All becomes clear having read the rest of this thread.
Agreed - I even tried it on two different computers!!
Katharine Dobson (Hills) 6.14, 1959 - 1965
Scone Lover
Grecian
Posts: 897
Joined: Sun Oct 15, 2006 2:45 pm

Post by Scone Lover »

What about even earlier than Page 10, what about page 5, there is stuff on there that hasn't been touched for absolutely ages. either that or a time limit of six months say before automatic closure
User avatar
cj
Button Grecian
Posts: 1738
Joined: Wed Mar 01, 2006 10:35 pm
Real Name: Catherine Standing
Location: Devon

Post by cj »

Keeping in CH and CH-related topics is important as this is essentially what the forum is about. General conversation needs to be pruned every so often, 3 or 4 months sounds about right. We can then carry on our inane and random chit-chat withour feeling too guilty about taking up too much cyber-space!
Catherine Standing (Cooper) Image
Canteen Cath 1.12 (1983-85) & Col A 20 (1985-90)

Any idiot can deal with a crisis. It takes a genius to cope with everyday life.
User avatar
Mrs C.
Button Grecian
Posts: 2300
Joined: Wed Feb 16, 2005 2:22 pm
Real Name: Janet Chandler
Location: C.H.

Post by Mrs C. »

Scone Lover wrote:What about even earlier than Page 10, what about page 5, there is stuff on there that hasn't been touched for absolutely ages. either that or a time limit of six months say before automatic closure
oh dear, Sean`s found all that to go at now!!!

(have posted somewhere else on same subject , but thanks JT!)
The best way to forget your troubles is to wear tight shoes.
User avatar
Richard Ruck
Button Grecian
Posts: 3120
Joined: Wed Feb 02, 2005 12:08 pm
Real Name: Richard Ruck
Location: Horsham

Post by Richard Ruck »

Scone Lover wrote:What about even earlier than Page 10, what about page 5, there is stuff on there that hasn't been touched for absolutely ages. either that or a time limit of six months say before automatic closure
A few thoughts about this.

Firstly, new forum members (especially those who have a lot to say :wink: ) may find it useful to look back at old topics / comments and be able to discuss them themselves. I think that this could be increasingly important as time goes by, as new arrivals may make valuable contributions to discussions which have currently run out of steam for us.

As an example, DBTS started a very amusing topic ages ago entitled "Mass nudity in the Swimming Baths". No-one has added to it for many months, but it would be a real shame if it was unavailable to newer members (no pun intended).

Also, just because stuff hasn't been 'touched' it doesn't mean that it hasn't been read or used for reference by someone.

Secondly, I'm really not comfortable with the idea of the originator of a particular thread somehow claiming 'ownership' of it.

Some of the most interesting and lively threads have been prompted by a simple question or comment from the originator, with other forum members weighing in with intelligent / useful / hilarious contributions, and provided these contribution stay within the parameters of acceptable use of the forum I don't see why other forum members (moderators excepted) should effectively have the power of censorship over them.
Ba.A / Mid. B 1972 - 1978

Thee's got'n where thee cassn't back'n, hassn't?
User avatar
Mrs C.
Button Grecian
Posts: 2300
Joined: Wed Feb 16, 2005 2:22 pm
Real Name: Janet Chandler
Location: C.H.

Post by Mrs C. »

I`m inclined to agree with you Richard - the more "serious" topics - or should I say, the ones which were inclined to stay on topic, were during the earlier phase of the forum when people hadn`t really "got to know" each other. But in almost every thread there is something of interest so it could be difficult to prune on "age" alone.
I`m sure I wouldn`t like to have to decide what goes and what stays!
The best way to forget your troubles is to wear tight shoes.
Vonny
Button Grecian
Posts: 1625
Joined: Sat Dec 11, 2004 7:33 pm
Real Name: Yvonne Payne

Re: A solution to keeping database size down?

Post by Vonny »

jtaylor wrote:Here's an idea - we could enable auto-pruning (sounds painful!) on the "General Chat - Non CH" section, which would automatically remove any topic which hasn't been accessed for any specified period - e.g. 3 months?.
That sounds good. I moderate on another forum and this is what happens there.
2's 1981-1985 2:12 BaB 1985-1988 BaB 41
User avatar
Great Plum
Button Grecian
Posts: 5282
Joined: Wed Dec 15, 2004 10:59 am
Real Name: Matt Holdsworth
Location: Reigate

Post by Great Plum »

I'm in agreement with Vonny I think. I post on another forum (when I have time!) and they auto prune everything on their 'chat' forum after 3 months - and have an archived forum for anything that maybe interesting.

Bear in mind they have at least 50 people online all the time.

I don't like the idea that we should delete threads just because the originator of the thread thinks they are finished though.
Maine B - 1992-95 Maine A 1995-99
User avatar
jtaylor
Forum Administrator
Posts: 1887
Joined: Sat Jun 05, 2004 12:32 am
Real Name: Julian Taylor
Location: Wantage, OXON
Contact:

Post by jtaylor »

The easiest approach is the auto-prune, but JUST on the General Chat - Non CH section.

Any topics which contain CH or Old-Blue specific content can be moved into the CH section??
Julian Taylor-Gadd
Leigh Hunt 1985-1992
Image
Founder of The Unofficial CH Forum
https://www.grovegeeks.co.uk - IT Support and website design for home, small businesses and charities.
Katharine
Button Grecian
Posts: 3316
Joined: Mon Dec 26, 2005 10:44 pm
Real Name: Katharine Dobson
Location: Gwynedd

Post by Katharine »

I would agree that threads don't belong to anyone - there are a few examples of short threads that didn't go off course eg my plea for help over Halloween stories when I had particularly asked you all to stay on topic (and you listened!!)

I do belong to another forum and that does regular archiving of some sections and cutting of the chat sections. Nobody seems to object to that -yes the postcount does go down when it happens but there is no classification as here. I think the software must be similar to this.
Katharine Dobson (Hills) 6.14, 1959 - 1965
User avatar
blondie95
Button Grecian
Posts: 2590
Joined: Tue Jun 06, 2006 4:41 pm
Real Name: Amy Leadbeater
Location: Kent
Contact:

Post by blondie95 »

i agree that things need to be rpuned, i dont think those that starterd a topoci should have decision about if it stays or goes.

And thank goodness your back I had a right panic last night when i couldnt get on here!
User avatar
Richard Ruck
Button Grecian
Posts: 3120
Joined: Wed Feb 02, 2005 12:08 pm
Real Name: Richard Ruck
Location: Horsham

Post by Richard Ruck »

blondie95 wrote:i agree that things need to be rpuned, i dont think those that starterd a topoci should have decision about if it stays or goes.

And thank goodness your back I had a right panic last night when i couldnt get on here!
"rpuned" - this has been happening to whales around Iceland recently! :wink:

Just out of interest, have you ever used the 'preview' function before submitting a post? It's very handy..........
Ba.A / Mid. B 1972 - 1978

Thee's got'n where thee cassn't back'n, hassn't?
User avatar
Mid A 15
Button Grecian
Posts: 3189
Joined: Thu May 19, 2005 1:38 pm
Real Name: Claude Rains
Location: The Patio Of England (Kent)

Post by Mid A 15 »

Richard Ruck wrote:
Scone Lover wrote:What about even earlier than Page 10, what about page 5, there is stuff on there that hasn't been touched for absolutely ages. either that or a time limit of six months say before automatic closure
Secondly, I'm really not comfortable with the idea of the originator of a particular thread somehow claiming 'ownership' of it.
Neither am I. It was intended as a suggestion to put the onus on US to seek out the threads we want to keep that might exceed the 3 month (or whatever) autoprune deadline.

I've now made a post on one thread in particular which I thought was a credit to the forum in the way it was conducted.

Maybe that is the answer simply make a post on a thread that you want to keep if it is over 3 months old.
Ma A, Mid A 65 -72
User avatar
Richard Ruck
Button Grecian
Posts: 3120
Joined: Wed Feb 02, 2005 12:08 pm
Real Name: Richard Ruck
Location: Horsham

Post by Richard Ruck »

Mid A 15 wrote:Maybe that is the answer simply make a post on a thread that you want to keep if it is over 3 months old.
This may well be a good compromise, but I'm still slightly worried that newcomers will be denied access to the many pages of wit and wisdom :roll: that are bound to be overlooked.
Ba.A / Mid. B 1972 - 1978

Thee's got'n where thee cassn't back'n, hassn't?
User avatar
Mid A 15
Button Grecian
Posts: 3189
Joined: Thu May 19, 2005 1:38 pm
Real Name: Claude Rains
Location: The Patio Of England (Kent)

Post by Mid A 15 »

Richard Ruck wrote:
Mid A 15 wrote:Maybe that is the answer simply make a post on a thread that you want to keep if it is over 3 months old.
This may well be a good compromise, but I'm still slightly worried that newcomers will be denied access to the many pages of wit and wisdom :roll: that are bound to be overlooked.
I'd rather keep everything too but I was under the impression that the forum would blow a gasket if we didn't prune stuff.

Hence the question as to the best way to do this and my responses.
Ma A, Mid A 65 -72
Post Reply