Lucene:Index的空间和时间实验

    技术2022-05-11  68

    硬件: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)  

    最新回复(0)