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, 1612🔥, 0💬
Popular Posts:
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter...
How to convert a date and time to a standard format? Date and time can be displayed in a number of s...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to validate domain name format? In order to help your programming or testing tasks, FYIcenter.co...
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter...