硬件:IBM X365
数据库:MySQL,7个域(1个int,4个string,2个MediumText)
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | mediumtext | NO | MUL | | |
| location | varchar(200) | NO | MUL | | |
| source | varchar(300) | NO | UNI | | |
| description | mediumtext | NO | | | |
| company | mediumtext | NO | | | |
| url | varchar(300) | NO | | | |
| degree | varchar(30) | YES | | NULL | |
| language | varchar(20) | YES | | NULL | |
| experience | varchar(50) | YES | | NULL | |
| trade | varchar(30) | NO | MUL | | |
| post_date | datetime | NO | MUL | | |
| end_date | datetime | YES | | NULL | |
+-------------+------------------+------+-----+---------+----------------+
实验1:
7个字段:除description,id字段其他都store
3138306 total milliseconds
52.3051 total mins
0.8717516666666667 total hours
1416797 records indexed!
index大小:800M左右 (838897729 byte)
实验2:
7个字段:除description,id字段其他都store
2774582 total milliseconds
46.24303333333334 total mins
0.7707172222222223 total hours
1416797 records indexed!
index大小:800M左右(838897729 byte)
实验3:
7个字段:都store
3499678 total milliseconds
58.32796666666667 total mins
0.9721327777777777 total hours
1416797 records indexed!
index大小:1600M左右 (1600718458 byte)