|
|
08-13-2019, 10:13 PM | #2 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
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:
Last edited by DaFace; 08-13-2019 at 10:37 PM.. |
Posts: 51,982
|
3 0 |
08-14-2019, 05:41 AM | #3 | |
Starter
Join Date: Jun 2019
|
Quote:
|
|
Posts: 574
|
08-14-2019, 06:18 AM | #4 | |
Please squeeze
Join Date: Jul 2003
Location: Clinton, MO
|
Quote:
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,416
|
08-14-2019, 07:02 AM | #5 | |
Starter
Join Date: Jun 2019
|
Quote:
Migrating to another software such as Xenforo would be pretty much the same as they have conversion scripts. Just more time consuming. |
|
Posts: 574
|
08-14-2019, 12:05 PM | #6 |
Has a particular set of skills
Join Date: Dec 2003
Location: On the water
|
so all accounts and history are wiped out, on purpose. How do you think that’s going to go over with the posters?
|
Posts: 79,274
|
08-14-2019, 12:18 PM | #7 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
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,982
|
1 0 |
08-14-2019, 12:24 PM | #8 | |
Tossed Salad & Scrambled Eggs
Join Date: Jan 2009
Location: ATX & OPKS
|
Quote:
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,756
|
08-14-2019, 01:01 PM | #9 | |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
Quote:
|
|
Posts: 51,982
|
08-14-2019, 12:46 PM | #10 | ||
Please squeeze
Join Date: Jul 2003
Location: Clinton, MO
|
Quote:
BRC change is inevitable that is just life. As Daface said you can keep a read-only archive if you are feeling nostalgic Quote:
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,416
|
08-14-2019, 01:06 PM | #11 | |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
Quote:
|
|
Posts: 51,982
|
08-14-2019, 01:04 PM | #12 |
In Search of a Life
Join Date: Jan 2010
Location: L.A.
|
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,314
|
08-14-2019, 01:07 PM | #13 |
Ain't no relax!
Join Date: Sep 2005
|
|
Posts: 47,697
|
08-14-2019, 04:49 PM | #14 |
Shaken. Not stirred.
Join Date: Sep 2002
Location: London
|
We already use discourse for chat here. That's all it's good for.
|
Posts: 65,558
|
|
|