databases: rows per second vs tps?

Comments

  • Rows per second is how many rows of a given table can be updated, retrieved, etc. It depends on the size of the tables and the contents of the rows.

    "tps" is transactions per second. A transaction may include more than one row, or it may include part of one row, depending again on the size of the tables and the contents of the rows.

    E.g, if your table contains two columns, "state abbreviation", and "state name", and you run a query such as:

    select * from states;

    You may well get all 50 states (50 rows) in one single database request.

Sign In or Register to comment.