maximum database inserts/second
I am working on a php project that is expected to have 1,000 active users at any instance and i am expecting 1,000 inserts or selects per second.
The question is, if my table uses innoDB Engine and suppose i do not use Transactions,e.t.c to achieve better performance, what is the maximum number of concurrent reads/writes that an innoDB table can handle per second ?
I have 1 table containing 5 columns with 1 index column.
Subject
Views
Written By
Posted
maximum database inserts/second
6704
July 19, 2016 12:09AM
3237
July 20, 2016 09:50AM
2157
July 20, 2016 09:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.