Lisa it depends on more than just the db. What server is it running on (its own or shared), are the tables indexed, are the queries optimised???

All these factors come into play before you start optimizing MYSQL...

Kind regards, Spencer

Lisa,

PM me with some info about the config of the server and what kind of transaction it is, read or write. Also, I would need some info about the application that is connected to the server and that generate those transactions.

Reaching 100k transaction per hour shouldn't be a problem if you have a decent hardware and if the program connected to the database has been developed correctly.

Patrice

I would have to say tuning the your application is likely to net you better results.

Typically what I see is not so much a problem with the MySQL database schema, but just poorly written applications that access the database. That's kind of a universal problem, not just with the MySQL platform.

There are exceptions though, like if the developer just didn't add any indexing... Sometimes over indexing is a problem as well.

try mysql performance blog for more detail or pm me i will optmize your mysql setting on server