Go to Villagebet.com.au for free horse racing tips - Click here now
Forum Home Forum Home > Community - Public Forums > Village Administration - Support and Feedback
  New Posts New Posts RSS Feed - Major size exceeded issue
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Thoroughbred Village Home Page. For village news, follow @TBVillage on Twitter. For horseracing tips, follow @Villagebet on Twitter. To contact the Mayor by email: Click Here.


Major size exceeded issue

 Post Reply Post Reply Page  12>
Author
Message
Mayor View Drop Down
Admin Group
Admin Group


Joined: 15 Feb 2007
Location: Australia
Status: Offline
Points: 3386
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mayor Quote  Post ReplyReply Direct Link To This Post Topic: Major size exceeded issue
    Posted: 19 Jul 2019 at 12:18pm
It seems we have almost run out of allotted space on the web server. The recommendation is that we move to a dedicated server rather than shared. The cost is prohibitive (USD$45.89 per month). Not sure what to do. One option is to completely start again, with obvious impact on members, 19 years of messages, and SEO factors. This is a nightmare as thousands of Google errors will be thrown and we will most likely be severely penalised for it. What do you guys think? It would be a good opportunity to restart in mid winter, but our organic hits will plummet, affecting advertising. I guess I have to weigh up the impact of the hit in SEO against the savings of starting again. I can't afford an extra AUD$800 per year for a dedicated server. Any thoughts? Mayor
Mayor
Back to Top
oneonesit View Drop Down
Champion
Champion
Avatar

Joined: 06 Aug 2012
Status: Offline
Points: 36895
Post Options Post Options   Thanks (0) Thanks(0)   Quote oneonesit Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 6:13pm
Pretty easy solution Mayor as i see it. Couple of the punters in the racing section reckon they always finish in the black across a year.. Get them to increase their investment & let them pay the $800. Everyones a winner that way Big smile
Refer ALP Election Promises
Back to Top
crooked_gambler View Drop Down
Champion
Champion
Avatar

Joined: 27 Jan 2015
Status: Offline
Points: 4675
Post Options Post Options   Thanks (0) Thanks(0)   Quote crooked_gambler Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 6:28pm
Could always start a go fund me and get everyone to chip in $5
This space has been intentionally left blank
Back to Top
Second Chance View Drop Down
Champion
Champion
Avatar

Joined: 02 Dec 2007
Status: Offline
Points: 45319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Second Chance Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 6:30pm
Very few looks so far Mr Mayor.  I'd suggest posting in some of the other forums.
Back to Top
Gay3 View Drop Down
Moderator Group
Moderator Group


Joined: 19 Feb 2007
Location: Miners Rest
Status: Offline
Points: 51818
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gay3 Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 6:51pm
Something like Imminent Forum Closure should get attention especially if placed in Racing & pinned.
Wisdom has been chasing me but I've always outrun it!
Back to Top
furious View Drop Down
Champion
Champion


Joined: 19 Feb 2007
Status: Offline
Points: 25066
Post Options Post Options   Thanks (0) Thanks(0)   Quote furious Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 7:53pm
Well I'm only in and out as it's a bit boring at the moment.  Everyone is talking everything but racing!  Do you want this site to be everything or racing.  If you cut out all the backup extras and just kept racing or breeding back to the old days (mind you I can never find anything anyway) maybe you'd help the amount of space needed.  Just a thought.
Back to Top
Mayor View Drop Down
Admin Group
Admin Group


Joined: 15 Feb 2007
Location: Australia
Status: Offline
Points: 3386
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mayor Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 8:10pm
I'd prefer to talk about racing and breeding only, but this is a community and people like to discuss many other things, that's fine. I've been talking to the hosting manager, the forum posts are using 95% of the entire website's footprint. If the price is prohibitive, he suggests removing old posts. I wonder what the impact of that is, in terms of people wanting to maintain access to old posts and also, what is the SEO impact of removing content. I'm working through these issues. I didn't want this to be a fund raising exercise though, I'd prefer to have a practical solution.. the database is very very large.... millions and millions of posts.
Mayor
Back to Top
SkyDancer View Drop Down
Champion
Champion
Avatar

Joined: 02 Aug 2014
Location: Cranbourne
Status: Offline
Points: 8428
Post Options Post Options   Thanks (1) Thanks(1)   Quote SkyDancer Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 8:13pm
Anything that hasn’t been used in 3-4 years is fair game for removal IMO
Back to Top
furious View Drop Down
Champion
Champion


Joined: 19 Feb 2007
Status: Offline
Points: 25066
Post Options Post Options   Thanks (0) Thanks(0)   Quote furious Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 8:27pm
Just delete it Mayor.  We'll live on and have our own data bases to rely on for old information.
Back to Top
Passing Through View Drop Down
Champion
Champion
Avatar

Joined: 09 Jan 2013
Location: At home
Status: Offline
Points: 79533
Post Options Post Options   Thanks (0) Thanks(0)   Quote Passing Through Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 8:30pm
In Racing and Joffs only about 10% of posts have been viewed in the last 2 years by anyone but bots.
Back to Top
Gay3 View Drop Down
Moderator Group
Moderator Group


Joined: 19 Feb 2007
Location: Miners Rest
Status: Offline
Points: 51818
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gay3 Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 8:40pm
Just a thought which I know annoys others too, many insist on using the Quote tab for every reply despite it being immediately above, surely this would add to space usage?
I'm thinking of the future.

Wisdom has been chasing me but I've always outrun it!
Back to Top
VOYAGER View Drop Down
Champion
Champion
Avatar

Joined: 04 Aug 2007
Location: Australia
Status: Offline
Points: 18699
Post Options Post Options   Thanks (0) Thanks(0)   Quote VOYAGER Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 9:41pm
I think the start again option would be easier.

However I also think there are a few forums which can be eliminated, as they have low volume.

Threads which have not had any posts for a certain amount of time (again this is a moving option but for me, 5 years would be okay) should go.

Any threads which have had less than one page of posts should go. I have noticed in the last 12 months that if a horse wins a maiden at the mid weeks it gets a thread. I think this is taking up valuable space.

I think if a member wants to pay for a forum that could be an option. So for instance I would be willing to pay $50 a month, for the Tipping Forum to continue.

It would be a shame to lose all the contributions from the past posters like Kangamick, Joffs and andy, but if that needs to be done to save the Village, then that is what, has to happen.

Not sure if that post helps.
Remember, it might take intelligence to be smart , but it takes experience to be wise
Back to Top
Whale View Drop Down
Champion
Champion
Avatar

Joined: 01 Jun 2009
Location: St Kilda Beach
Status: Offline
Points: 38719
Post Options Post Options   Thanks (0) Thanks(0)   Quote Whale Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 10:40pm
I believe the falafel van business is very good, Doc could pay the $800 from petty cash
Back to Top
Mayor View Drop Down
Admin Group
Admin Group


Joined: 15 Feb 2007
Location: Australia
Status: Offline
Points: 3386
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mayor Quote  Post ReplyReply Direct Link To This Post Posted: 19 Jul 2019 at 11:38pm
First thing, I'm going to backup the forum SQL database, so all the 1.5 million posts will be saved. Not sure exactly the best way to access individual posts in the backup file but at least I know it's possible in case something is needed. Then I'll look at the best way to remove old redundant threads.
Mayor
Back to Top
Red Hare View Drop Down
Champion
Champion


Joined: 12 Jan 2015
Location: Victoria
Status: Offline
Points: 4233
Post Options Post Options   Thanks (0) Thanks(0)   Quote Red Hare Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 1:17am
Originally posted by Gay3 Gay3 wrote:

Just a thought which I know annoys others too, many insist on using the Quote tab for every reply despite it being immediately above, surely this would add to space usage?
I'm thinking of the future.

Edit button would surely result in a significant reduction here.
Back to Top
Red Hare View Drop Down
Champion
Champion


Joined: 12 Jan 2015
Location: Victoria
Status: Offline
Points: 4233
Post Options Post Options   Thanks (0) Thanks(0)   Quote Red Hare Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 1:24am
Originally posted by Mayor Mayor wrote:

I'd prefer to talk about racing and breeding only, but this is a community and people like to discuss many other things.
That might’ve been the case back in the day, but Joffs is now just the same handful of posters having the same argument in every thread.

I guess you’ll have to weigh up the income from clicks v benefits of sterner moderation.
Back to Top
VSP. View Drop Down
Premium
Premium
Avatar

Joined: 19 Feb 2007
Location: Australia
Status: Offline
Points: 8315
Post Options Post Options   Thanks (0) Thanks(0)   Quote VSP. Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 1:43am
Originally posted by Mayor Mayor wrote:

..... The cost is prohibitive (USD$45.89 per month). .....
Is this total cost to host the forum? Approx Aus$850 per year? Surely the advertising and betting commissions pay that easily? I seem to remember contributing that kind of money in the past for a year's running costs, so what has changed?


Edited by VSP. - 20 Jul 2019 at 1:43am
www.snowshoecats.webs.com
Back to Top
Brudder_A View Drop Down
Champion
Champion


Joined: 01 Apr 2013
Location: Uzhhorod
Status: Offline
Points: 4220
Post Options Post Options   Thanks (0) Thanks(0)   Quote Brudder_A Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 5:10am
If possible couldn't you do archival of post older than 5-7 years? Space would be freed up. An archival area that is cost efficient and accessible would be nice.



Thanks, I can do that quite easily, however to reduce the size of the file, the old posts would need to be removed from the database and not be accessible to the public anymore (although I have them on file). An archive wouldn't achieve that. Mayor


Edited by Mayor - 20 Jul 2019 at 8:38am
Back to Top
Mayor View Drop Down
Admin Group
Admin Group


Joined: 15 Feb 2007
Location: Australia
Status: Offline
Points: 3386
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mayor Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 8:31am
Originally posted by VSP. VSP. wrote:

Originally posted by Mayor Mayor wrote:

..... The cost is prohibitive (USD$45.89 per month). .....
Is this total cost to host the forum? Approx Aus$850 per year? Surely the advertising and betting commissions pay that easily? I seem to remember contributing that kind of money in the past for a year's running costs, so what has changed?


Nothing's changed other than the fact that the forum database has overgrown its current storage capacity. It can't continue to be housed on a shared server (it's at 96% capacity) and must transfer to a dedicated cloud-based server. The cost mentioned is for storage and efficient running of the full database on a dedicated server. The alternative is to reduce its size by deleting old posts. This is not my preference as personally, I access old posts from time to time, mainly to source information for articles.

The TBV forums have always been free for members and there are absolutely no plans to introduce membership fees.
Mayor
Back to Top
Shrunk in the Wash View Drop Down
Champion
Champion


Joined: 25 Mar 2016
Status: Offline
Points: 9890
Post Options Post Options   Thanks (0) Thanks(0)   Quote Shrunk in the Wash Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 9:37am
Originally posted by Red Hare Red Hare wrote:

Originally posted by Gay3 Gay3 wrote:

Just a thought which I know annoys others too, many insist on using the Quote tab for every reply despite it being immediately above, surely this would add to space usage?
I'm thinking of the future.

Edit button would surely result in a significant reduction here.



Spot on
Back to Top
Brudder_A View Drop Down
Champion
Champion


Joined: 01 Apr 2013
Location: Uzhhorod
Status: Offline
Points: 4220
Post Options Post Options   Thanks (1) Thanks(1)   Quote Brudder_A Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 9:48am
Originally posted by Mayor Mayor wrote:

Thanks, I can do that quite easily, however to reduce the size of the file, the old posts would need to be removed from the database and not be accessible to the public anymore (although I have them on file). An archive wouldn't achieve that. Mayor


Removing non-thoroughbred old posts would sanitize the forum and would regain some space - as well as focus...

You will need to make a decision!


Back to Top
maccamax View Drop Down
Champion
Champion


Joined: 19 Jun 2010
Status: Offline
Points: 41473
Post Options Post Options   Thanks (0) Thanks(0)   Quote maccamax Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 4:24pm
I'd suggest "Old Posts " would be better , gone & forgotten anyway.

Back to Top
Second Chance View Drop Down
Champion
Champion
Avatar

Joined: 02 Dec 2007
Status: Offline
Points: 45319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Second Chance Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 4:42pm
Racing has the historical volume.  Then Joffs followed by Tipping.

Suggest just rid all posts in Racing and Joffs older than say 3 years plus all Tipping more than a year oldand see how much space that frees up.
Back to Top
oneonesit View Drop Down
Champion
Champion
Avatar

Joined: 06 Aug 2012
Status: Offline
Points: 36895
Post Options Post Options   Thanks (0) Thanks(0)   Quote oneonesit Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 6:48pm
How about this approach. For starters - randomly select 4 letters of the alphabet & just delete all posts in Joffs from posters whose name starts with one of those letters. To make it easy i have just done same - & pulled out the following letters from a bag full of letters - W, P, R & T . See how that goes.
Refer ALP Election Promises
Back to Top
Second Chance View Drop Down
Champion
Champion
Avatar

Joined: 02 Dec 2007
Status: Offline
Points: 45319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Second Chance Quote  Post ReplyReply Direct Link To This Post Posted: 20 Jul 2019 at 7:10pm
Well we all appreciate a bit of humor on here O.  My randoms however came up with O, D, M and S.  Wink


Back to Top
Mayor View Drop Down
Admin Group
Admin Group


Joined: 15 Feb 2007
Location: Australia
Status: Offline
Points: 3386
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mayor Quote  Post ReplyReply Direct Link To This Post Posted: 21 Jul 2019 at 12:13am
The deleting function will remove topics that haven't been posted in for say, a couple of years.

So, if you have an interest in a particular topic, but it hasn't been added to for over a year or so, please post something in the thread and it will remain in the database.

Regards, Mayor
Mayor
Back to Top
saintly96 View Drop Down
Champion
Champion
Avatar

Joined: 12 Jun 2008
Location: Nunya biz
Status: Offline
Points: 12926
Post Options Post Options   Thanks (0) Thanks(0)   Quote saintly96 Quote  Post ReplyReply Direct Link To This Post Posted: 21 Jul 2019 at 1:52am
We could all donate 5 or 10 bucks. I am sure that would cover the cost mentioned.
Back to Top
Second Chance View Drop Down
Champion
Champion
Avatar

Joined: 02 Dec 2007
Status: Offline
Points: 45319
Post Options Post Options   Thanks (0) Thanks(0)   Quote Second Chance Quote  Post ReplyReply Direct Link To This Post Posted: 21 Jul 2019 at 7:28pm
Am way against donations, if only because it allows free riders to continue without contributing.

Archiving Racing and Joffs threads more than three years old and Tipping one year old would surely free up tons of space.
Back to Top
Whale View Drop Down
Champion
Champion
Avatar

Joined: 01 Jun 2009
Location: St Kilda Beach
Status: Offline
Points: 38719
Post Options Post Options   Thanks (0) Thanks(0)   Quote Whale Quote  Post ReplyReply Direct Link To This Post Posted: 21 Jul 2019 at 8:06pm
Can't see a problem with donations, people get it free now anyway.
and it is a bit like taxpayers paying for Centrelink, hospitals, roads etc that non taxpayers use.
Maybe those contributing can get a small reward, something like edit function
Back to Top
VSP. View Drop Down
Premium
Premium
Avatar

Joined: 19 Feb 2007
Location: Australia
Status: Offline
Points: 8315
Post Options Post Options   Thanks (0) Thanks(0)   Quote VSP. Quote  Post ReplyReply Direct Link To This Post Posted: 21 Jul 2019 at 8:33pm
There have been offers from Big Al & Voyager to each cover a year of the full costs to keep the place going. Thats two full years before anyone has to worry. Not quite sure why the Mayor is dismissing the offers?
www.snowshoecats.webs.com
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.05
Copyright ©2001-2022 Web Wiz Ltd.

This page was generated in 0.094 seconds.