Collections:
Table for IOPS Tests on INSERT Statements
How to design a database table to perform IOPS tests on INSERT Statements?
✍: FYIcenter.com
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, 1539🔥, 0💬
Popular Posts:
How to generate MAC addresses? To help you to obtain some MAC addresses for testing purpose, FYIcent...
How to Open and Close Internet Explorer with UFT script? One way to open and close Internet Explorer...
How to Pass Windows Environment Variable to JMeter? I want to use Windows temporary folder environme...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter...