I manage a Informix database of up to 1.5 million items, with large associated blob items, and it runs like a charm on a modest HP Unix server.
Makes me wonder about the tiny little MySQL stuff I play with on the side.
Informix, wow, didn’t even know it still existed. I did some Informix projects back in the mid 80’s. Worked great.
300,000 objects in a database is trivial. MySQL certainly isn’t the problem. Either the data architecture is bad, the host is bad, or you have some super large objects...