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