Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room
Reload this Page ChiefsPlanet (Welcome to the) NEW Chiefsplanet SERVER!!!!
Register FAQDonate Members List Calendar

Reply
 
Thread Tools Display Modes
Old 08-14-2019, 06:18 AM   #1
dirk digler dirk digler is offline
Please squeeze
 
dirk digler's Avatar
 

Join Date: Jul 2003
Location: Clinton, MO
Casino cash: $3024644
Quote:
Originally Posted by DaFace View Post
MariaDB 10.0.38. Most of the tables are MyISAM. I've debated messing around and seeing what would happen if I changed the POST table (which is the problem) to InnoDB, but it would likely take hours to change it and hours to change back if it still sucks. Plus, it could also royally break stuff. So I've decided I'm probably not the best one to do it.

At some point, if we decide we're just going to live with this software forever, we may need to consider pruning the database down. I've mulled over something like cloning the site and DB, then putting it at a different URL as a pure archive (no new posts), then pruning the active CP site down to just threads/posts from the past 5 years or something. Constantly sorting a 13 GB table almost has to be the biggest issue. There are better ways of doing the query in newer versions of vBulletin, but the queries in this version suck donkey balls.

The one hardware upgrade that I wonder might help would be to move to a server where we could throw the entire database onto SSDs rather than HDDs. I could be wrong, but it seems like IO is probably the issue, so moving the DB onto a drive that would respond a lot faster might help. Maybe.

So for what it's worth, here are the options as I see them:
  • Live with what we have. Possibly try a few things that probably won't help much. The end.
  • Try a hardware upgrade (new server with SSDs for storage maybe). Might not really help much. Tough to say. But could work. Very time intensive for AC.
  • Prune the database. Some loss of functionality (couldn't bump a 15-year old thread, which can be fun sometimes). Moderate amount of time for AC.
  • Move to completely different software. We'd gain a lot of features in "modern" software, but we'd lose some functionality people are used to here for sure. Rep would work differently. Thumbs would work differently. Categories and prefixes would work differently. Mod options like thread bans might not work. It would almost certainly fix the lag issues, but there are plenty of sites out there that have gone under due to major functionality changes, so it's not a decision to make lightly. Would be an insane amount of work for AC and high amount of work for others like me and Bearcat to try and tweak all of the settings to make things as familiar as possible.
As an IT person I would do the last option because I hate keeping around super old software just because. And if you were going to do that and the cost wasn't to bad I would move it to Azure or AWS.

The downside of that is probably no way to import accounts and post history outside of that there is no feature that I couldn't do without that I depend on. People would get used to it.
Posts: 66,394
dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 07:02 AM   #2
limested limested is offline
Starter
 

Join Date: Jun 2019
Casino cash: $10000400
Quote:
Originally Posted by dirk digler View Post
As an IT person I would do the last option because I hate keeping around super old software just because. And if you were going to do that and the cost wasn't to bad I would move it to Azure or AWS.

The downside of that is probably no way to import accounts and post history outside of that there is no feature that I couldn't do without that I depend on. People would get used to it.
Upgrading to newest VB would be seamless minus a few feature losses.
Migrating to another software such as Xenforo would be pretty much the same as they have conversion scripts. Just more time consuming.
Posts: 574
limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.limested is not part of the Right 53.
     Reply With Quote
Old 08-14-2019, 12:05 PM   #3
BigRedChief BigRedChief is offline
Has a particular set of skills
 
BigRedChief's Avatar
 

Join Date: Dec 2003
Location: On the water
Casino cash: $2879627
VARSITY
Quote:
Originally Posted by dirk digler View Post
The downside of that is probably no way to import accounts and post history outside of that there is no feature that I couldn't do without that I depend on. People would get used to it.
so all accounts and history are wiped out, on purpose. How do you think that’s going to go over with the posters?
__________________
Time is worth more than money.
Posts: 79,209
BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.BigRedChief is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 12:18 PM   #4
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1766899
Quote:
Originally Posted by BigRedChief View Post
so all accounts and history are wiped out, on purpose. How do you think that’s going to go over with the posters?
Just to clarify, a move to either a new version of vBulletin or a move to Xenforo would both allow for accounts, threads, and posts to be migrated over (as limested mentioned earlier). Not sure about Discourse. Still a **** ton of work though.
Posts: 51,958
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
 Thumbs Up 1 Thumbs Down 0     Reply With Quote
Old 08-14-2019, 12:24 PM   #5
Dante84 Dante84 is offline
Tossed Salad & Scrambled Eggs
 
Dante84's Avatar
 

Join Date: Jan 2009
Location: ATX & OPKS
Casino cash: $1531996
VARSITY
Quote:
Originally Posted by DaFace View Post
Just to clarify, a move to either a new version of vBulletin or a move to Xenforo would both allow for accounts, threads, and posts to be migrated over (as limested mentioned earlier). Not sure about Discourse. Still a **** ton of work though.
Any idea what clearing out a subforum of 2Million posts would look like from a time ROI standpoint?

I'm sure there would ad revenue lost by deleting a forum that nets a lot of views.

In terms of performance improvement, what would that do?

And how much of a time investment would it take from you/AC/etc...?
__________________
..
Posts: 19,753
Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.Dante84 is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 01:01 PM   #6
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1766899
Quote:
Originally Posted by Dante84 View Post
Any idea what clearing out a subforum of 2Million posts would look like from a time ROI standpoint?

I'm sure there would ad revenue lost by deleting a forum that nets a lot of views.

In terms of performance improvement, what would that do?

And how much of a time investment would it take from you/AC/etc...?
Clearing it out wouldn't be a huge hassle. Wouldn't make a huge dent in our issues though. And you can bet it'd piss some people off pretty fiercely.
Posts: 51,958
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 12:46 PM   #7
dirk digler dirk digler is offline
Please squeeze
 
dirk digler's Avatar
 

Join Date: Jul 2003
Location: Clinton, MO
Casino cash: $3024644
Quote:
Originally Posted by BigRedChief View Post
so all accounts and history are wiped out, on purpose. How do you think that’s going to go over with the posters?

BRC change is inevitable that is just life. As Daface said you can keep a read-only archive if you are feeling nostalgic

Quote:
Originally Posted by DaFace View Post
Just to clarify, a move to either a new version of vBulletin or a move to Xenforo would both allow for accounts, threads, and posts to be migrated over (as limested mentioned earlier). Not sure about Discourse. Still a **** ton of work though.

If that is the case then moving to Xenforo sounds like a good plan. you could do a new server migration to VBulletin it looks like as well.
Posts: 66,394
dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.dirk digler is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 01:06 PM   #8
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1766899
Quote:
Originally Posted by dirk digler View Post
BRC change is inevitable that is just life. As Daface said you can keep a read-only archive if you are feeling nostalgic




If that is the case then moving to Xenforo sounds like a good plan. you could do a new server migration to VBulletin it looks like as well.
I've liked Xenforo for years, but there's no question it would be a massive undertaking - initially for AC, and in the long-term for anyone else who pitches in to help make it look and work well. It would be a complete, ground-up redo in terms of look and feel.
Posts: 51,958
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 01:04 PM   #9
suzzer99 suzzer99 is offline
In Search of a Life
 
suzzer99's Avatar
 

Join Date: Jan 2010
Location: L.A.
Casino cash: $2704284
Quote:
Originally Posted by DaFace View Post
Just to clarify, a move to either a new version of vBulletin or a move to Xenforo would both allow for accounts, threads, and posts to be migrated over (as limested mentioned earlier). Not sure about Discourse. Still a **** ton of work though.
Whatever we go with - auto-loading gameday and draft threads w/o having to refresh would be amazing for this forum. Which is also something I like about discourse - it has no pages - just endless scroll.
Posts: 27,305
suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 01:07 PM   #10
Fish Fish is online now
Ain't no relax!
 
Fish's Avatar
 

Join Date: Sep 2005
Casino cash: $2018919
Quote:
Originally Posted by suzzer99 View Post
Whatever we go with - auto-loading gameday and draft threads w/o having to refresh would be amazing for this forum. Which is also something I like about discourse - it has no pages - just endless scroll.
**** that...
__________________
Posts: 47,653
Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 01:18 PM   #11
suzzer99 suzzer99 is offline
In Search of a Life
 
suzzer99's Avatar
 

Join Date: Jan 2010
Location: L.A.
Casino cash: $2704284
Quote:
Originally Posted by Fish View Post
**** that...
Have you tried it? It's pretty sweet. Also it's hard to do auto-update with pages.
Posts: 27,305
suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.suzzer99 is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 03:21 PM   #12
Fish Fish is online now
Ain't no relax!
 
Fish's Avatar
 

Join Date: Sep 2005
Casino cash: $2018919
Quote:
Originally Posted by suzzer99 View Post
Have you tried it? It's pretty sweet. Also it's hard to do auto-update with pages.
Yes, I've used some apps and sites with that functionality, and I really hated it. It's less organized and lacks structure.
__________________
Posts: 47,653
Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.Fish is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 04:49 PM   #13
007 007 is offline
Shaken. Not stirred.
 
007's Avatar
 

Join Date: Sep 2002
Location: London
Casino cash: $13950126
VARSITY
Quote:
Originally Posted by suzzer99 View Post
Whatever we go with - auto-loading gameday and draft threads w/o having to refresh would be amazing for this forum. Which is also something I like about discourse - it has no pages - just endless scroll.
We already use discourse for chat here. That's all it's good for.
__________________
My dear girl, there are some things that just aren’t done. Such as, drinking Dom Perignon ’53 above the temperature of 38 degrees Fahrenheit. That’s just as bad as listening to the Beatles without earmuffs.
Posts: 65,557
007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.007 is obviously part of the inner Circle.
     Reply With Quote
Old 08-14-2019, 04:53 PM   #14
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1766899
Quote:
Originally Posted by 007 View Post
We already use discourse for chat here. That's all it's good for.
Discourse ≠ Dischord
Last edited by DaFace; 08-14-2019 at 05:13 PM..
Posts: 51,958
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
     Reply With Quote
Reply

« Previous Thread | > Nzoner's Game Room < | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump




All times are GMT -6. The time now is 09:57 PM.

Contact Us - ChiefsPlanet - Archive - Top

This is a test for a client's site.
Fort Worth Texas Process Servers
Covering Arlington, Fort Worth, Grand Prairie and surrounding communities.
Tarrant County, Texas and Johnson County, Texas.
Advertise with us!
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.