What are performance limits of a database?

Posted by Tommy on Server Fault See other posts from Server Fault or by Tommy
Published on 2010-12-24T11:26:29Z Indexed on 2010/12/24 19:55 UTC
Read the original article Hit count: 294

Filed under:
|
|
|
|

What are some rough performance limits (read/s, write/s) for a single database server (no master-slave architecture), assuming storage on disk? How many read/s, write/s, depending on the kind of disk? (SSD vs non-SSD) , assuming simple operations (select one row by primary key, update one row, correctly indexed). I assume this limit is dependent on disk seek/write.

EDIT: My question is more about getting rough metrics of the number of operations a database supports: to be able to know for example, if a new feature triggering 300 inserts/s can be supported without scaling out with additional servers.

© Server Fault or respective owner

Related posts about sql

Related posts about database