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, 1523🔥, 0💬
Popular Posts:
How to update hidden input value field value with WebDriver in Python? Normally, a hidden input valu...
Where to find tutorials on Test Management? I want to know how to manage software testing documents ...
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...
How to perform UUDecode (Unix-to-Unix Decode)? UUEncode is Unix-to-Unix encoding used on Unix system...