Quote:
Originally Posted by seamonster
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?".
|
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.