Quote:
Originally Posted by penguinz
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.
|
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.