Originally Posted by seamonster (Post 17327230)

I developed a piece of software that uses Sqlite to sync data between multiple different parties for offline replication (this was over two years ago). I load tested this on older hardware knowing that my potential customers might be running on trash. I can tell you that 16 million records worked fine. Shit, you can add up to a billion rows in SQLite if you really know what you're doing...
MySql was a state of the art database with a good query analyzer\engine...Not being able to query or insert into a table that small leads me to believe you've got a problem that's deeper than just COTS. But you've got it all figured out and are king snake here so that's up to you to solve. But if I were in your position (which I don't envy) I wouldn't turn my nose up and act like a prick because somebody said something as simple as "are we solving a hardware problem with more software?".

Originally Posted by penguinz (Post 17327363)

Comparing Sqlite performance and ancient, or even modern, MySQL is no comparison.

Big issue with these types of community softwares is that table indexes do not get set. Especially when you start adding in mods.

A good indexing could speed things up considerably but you are still running antiquated software. Both the bb software and the backend services.

Originally Posted by DaFace (Post 17327398)

vBulletin 3.8 is also just horrifically bad at query efficiency. I just checked for fun, and loading this page executed 39 queries just to give you an idea. Multiply that by 1000 people all mashing the reload button on game days, and it's just a mess. Plus it does all sorts of joins instead of utilizing indexes efficiently.

They've improved a lot of it on newer versions, which, again is why my personal preference would be to rip the bandaid off so we could get on software that's actually designed to work in 2024.

Originally Posted by scho63 (Post 17327233)

Why the sarcasm for people trying to help? :hmmm:

Originally Posted by DaFace (Post 17326875)

Eh, Xenforo or vBulletin 6 are both around $200 for the software and both have migration tools - that's really not the issue. I'd personally rather go with those rather than something open source since they tend to be better supported.

(But again, only one person's opinion matters here.)

Originally Posted by DaFace (Post 17327293)

Just to be clear, I'm just here to answer questions. I'm happy to provide a little insight into the issues, but there are no decisions that I'll be making. I'm happy to pontificate about my views on the best new software, but I have no desire to get into it any further than I already am. :)

The barrier here is largely just Kyle finding time to deal with it, not Kyle figuring out how to do things.

Originally Posted by stanleychief (Post 17328403)

I'd say switching to SSD or NVMe drives would net the biggest bang for the buck, assuming the server hardware supports them. That would likely at least cut down on the amount of time things would be offline.

I think I asked this a long time ago, but what about moving to a cloud solution like Xenforo cloud and increasing revenue via donations or ads to pay for the costs? It sounds like AC is busy with his day-to-day job and his time is limited a bit. That would shift these outages to being someone else's problem to solve.

Originally Posted by Pablo (Post 17327454)

I've found an accurate representation of everyone in this thread weighing in with their IT expertise:

https://pansci.asia/wp-content/uploa...e05fe3ed15.jpg

Originally Posted by DaFace (Post 17328585)

I've wondered about Xenforo cloud as well. Our traffic levels would likely be in their Enterprise tier that would require custom pricing (so more than $250/month). Whether our ad revenues would cover it, I don't know.

Originally Posted by Pablo (Post 17327454)

I've found an accurate representation of everyone in this thread weighing in with their IT expertise:

https://pansci.asia/wp-content/uploa...e05fe3ed15.jpg

Originally Posted by Pablo (Post 17327454)

I've found an accurate representation of everyone in this thread weighing in with their IT expertise:

https://pansci.asia/wp-content/uploa...e05fe3ed15.jpg

Originally Posted by Otter (Post 17328615)

Since this was bumped again, outside of the in memorandum section (which can be re-created easily) why exactly is a merger needed? Are there weirdos coming back and looking up old posts on the regular? And if so, should you care?

This place will fill up so fast just because of the novelty of recreating it new.

And Xenforo pro cloud guys are absolute professionals and Austin would be taking the headache of having to play EMS off his hands.