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, 556👍, 0💬
Popular Posts:
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has ...
How to generate user full names? Test user names are frequently needed in testing applications that ...
How to force JMeter to automatically flush test result to file immediately after each sampler is exe...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...
How to generate test phone numbers? Test phone numbers are frequently needed in testing applications...