Table for IOPS Tests on INSERT Statements
Q
How to design a database table to perform IOPS tests on INSERT Statements?
✍: FYIcenter.com
A
In order to for perform IOPS tests on INSERT Statements,
we should start with a simplest table first
using minimum database functionalities.
Here is an example of database table, FYI_INT, with only 1 column:
CREATE TABLE FYI_INT (QUANTITY INT)
This FYI_INT has no primary key, no index, no constrains, and no default values.
Each record has only 1 field called QUANTITY, which stores an integer using 4 bytes.
If we insert 1,000,000 records in this table, the database will grow with 4,000,000 bytes or 4 MB.
⇒ Input Operation Test with INSERT Statements
⇐ What Is IOPS (I/O Operations Per Second)
2019-08-08, 1710🔥, 0💬
Related Topics:
