| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135 |
- TsDB2 Benchmark 鈥?10,000 rows
- Database: bench_1788918502094966900.db
- CPUs: 32
- 1. 寤鸿〃 + 寤虹储寮?=====================
- 鍒涘缓琛? 1 0s N/A 4 fields
- 鍒涘缓 3 涓储寮?(Primary + BTree + Str) 3 0s N/A
- 2. 鎵归噺鎻掑叆 (澧?
- =====================
- 鎻掑叆瀹屾垚: 10,000 rows, 鑰楁椂 1.474s, 鍚炲悙 6786 rows/s
- 3. 涓€绾х储寮曟煡璇?(涓婚敭 B+ 鏍?
- =====================================
- PK 绮剧‘鍖归厤 Eq(id=N/2) 1 0s N/A id=5000
- PK 鑼冨洿鏌ヨ id>=N*0.5 AND id<N*0.5+100 100 21.0409ms 4753/s
- PK 鑼冨洿鏌ヨ id>=N*0.5 AND id<=N*0.5+100 101 29.0325ms 3479/s
- PK Gt(id>N-10) 10 0s N/A
- PK Le(id<=10) 10 0s N/A
- PK FindOne(id=N/3) 1 0s N/A age=70
- PK ORDER BY id ASC LIMIT 100 100 3.0146ms 33172/s first_id=1
- PK ORDER BY id DESC LIMIT 100 100 7.0038ms 14278/s first_id=10000
- PK COUNT(*) 10000 10.0141ms 998592/s
- PK SUM(age) 575000 0s N/A 575000
- PK MAX(score) / MIN(score) 2 15.0207ms 133/s max=999 min=0
- 4. 浜岀骇绱㈠紩鏌ヨ (B+ 鏍?idx_age)
- ======================================
- SEC 绮剧‘鍖归厤 Eq(age=50) 125 503.4碌s N/A
- SEC 鑼冨洿 age>=30 AND age<40 1250 144.0738ms 8676/s
- SEC 鑼冨洿 age>=80 AND age<=97 2250 40.1638ms 56021/s
- SEC Gt(age>90) 875 10.0195ms 87330/s
- SEC Le(age<=20) 0 0s N/A
- SEC ORDER BY age ASC LIMIT 50 50 12.0452ms 4151/s first_age=18
- SEC ORDER BY age DESC LIMIT 50 50 8.0037ms 6247/s first_age=97
- SEC COUNT(age>=50) 6000 90.2333ms 66494/s
- SEC SUM(score) WHERE age BETWEEN 25 AND 35 676500 142.3067ms 4753817/s 676500
- 5. 瀛楃涓茬储寮曟煡璇?(idx_name)
- ===================================
- STR 绮剧‘鍖归厤 Eq(name=last) 1 0s N/A
- STR 鑼冨洿 name>='U100' AND name<'U200' 0 148.7874ms 0/s
- 6. 鍏ㄨ〃鎵弿 + 澶嶆潅鏉′欢 (score 鏃犵储寮?
- ================================================
- 鍏ㄨ〃: score>900 990 0s N/A
- 鍏ㄨ〃: score>=500 AND score<=600 10 0s N/A
- 鍏ㄨ〃: In(score, [1,2,3,999]) 40 10.014ms 3994/s
- 鍏ㄨ〃: Not(Eq(age, 50)) 9875 1.5136ms 6524181/s
- 鍏ㄨ〃: Like(name, 'U100%') 0 0s N/A
- 鍏ㄨ〃: Or(Eq(age,18), Eq(age,97)) 250 0s N/A
- 7. 鎺掑簭娴嬭瘯
- ===============
- ORDER BY age ASC (鍐呭瓨鎺掑簭) 100 0s N/A sorted=true
- ORDER BY age DESC (鍐呭瓨鎺掑簭) 100 0s N/A sorted=true
- ORDER BY score ASC, age DESC (澶氬瓧娈? 10 8.5043ms 1176/s
- 8. 鍒嗙粍缁熻 (Scan 娴佸紡)
- =============================
- GROUP BY age 鈫?COUNT(*) (娴佸紡 Scan) 80 0s N/A 80 groups
- GROUP BY age 鈫?AVG(score) (娴佸紡 Scan) 80 10.0209ms 7983/s 80 groups
- 9. 鎵归噺鏇存柊 (鏀?
- =====================
- UPDATE score=0 WHERE id>=1 AND id<=N/10 1000 110.2171ms 9073/s
- 楠岃瘉: score=0 鐨勮鏁? 1009 10.0163ms 100736/s
- UPDATE age=99 WHERE age=18 (浜岀骇绱㈠紩鏉′欢) 112 5.5245ms 20273/s
- 10. 鎵归噺鍒犻櫎 (鍒?
- ======================
- DELETE WHERE id>N*0.9 988 34.5547ms 28592/s
- 楠岃瘉: 鍒犻櫎鍚庢€昏鏁? 9012 0s N/A
- DELETE WHERE age=97 (浜岀骇绱㈠紩鏉′欢) 100 10.0121ms 9988/s
- 鏈€缁? 鎬昏鏁? 8912 3.5158ms 2534843/s
- 11. OFFSET + LIMIT 鍒嗛〉
- =========================
- PK 鍒嗛〉: OFFSET N/2 LIMIT 10 10 6.5038ms 1538/s first_id=4989
- SEC 鍒嗛〉: OFFSET N/10 LIMIT 20 20 10.0251ms 1995/s first_age=19
- 鎬ц兘姹囨€绘姤鍛?==================
- 鎿嶄綔 琛屾暟 鑰楁椂 鍚炲悙(rows/s) 澶囨敞
- ------------------------------------------------------------------------------------------------------------------------
- 鍒涘缓琛? 1 0s N/A 4 fields
- 鍒涘缓 3 涓储寮?(Primary + BTree + Str) 3 0s N/A
- 鎵归噺鎻掑叆 10,000 1.474s 6786 6786 rows/s
- PK 绮剧‘鍖归厤 Eq(id=N/2) 1 0s N/A id=5000
- PK 鑼冨洿鏌ヨ id>=N*0.5 AND id<N*0.5+100 100 21ms 4753
- PK 鑼冨洿鏌ヨ id>=N*0.5 AND id<=N*0.5+100 101 29ms 3479
- PK Gt(id>N-10) 10 0s N/A
- PK Le(id<=10) 10 0s N/A
- PK FindOne(id=N/3) 1 0s N/A age=70
- PK ORDER BY id ASC LIMIT 100 100 3ms 33172 first_id=1
- PK ORDER BY id DESC LIMIT 100 100 7ms 14278 first_id=10000
- PK COUNT(*) 10,000 10ms 998592
- PK SUM(age) 575,000 0s N/A 575000
- PK MAX(score) / MIN(score) 2 15ms 133 max=999 min=0
- SEC 绮剧‘鍖归厤 Eq(age=50) 125 1ms N/A
- SEC 鑼冨洿 age>=30 AND age<40 1,250 144ms 8676
- SEC 鑼冨洿 age>=80 AND age<=97 2,250 40ms 56021
- SEC Gt(age>90) 875 10ms 87330
- SEC Le(age<=20) 0 0s N/A
- SEC ORDER BY age ASC LIMIT 50 50 12ms 4151 first_age=18
- SEC ORDER BY age DESC LIMIT 50 50 8ms 6247 first_age=97
- SEC COUNT(age>=50) 6,000 90ms 66494
- SEC SUM(score) WHERE age BETWEEN 25 AND 35 676,500 142ms 4753817 676500
- STR 绮剧‘鍖归厤 Eq(name=last) 1 0s N/A
- STR 鑼冨洿 name>='U100' AND name<'U200' 0 149ms 0
- 鍏ㄨ〃: score>900 990 0s N/A
- 鍏ㄨ〃: score>=500 AND score<=600 10 0s N/A
- 鍏ㄨ〃: In(score, [1,2,3,999]) 40 10ms 3994
- 鍏ㄨ〃: Not(Eq(age, 50)) 9,875 2ms 6524181
- 鍏ㄨ〃: Like(name, 'U100%') 0 0s N/A
- 鍏ㄨ〃: Or(Eq(age,18), Eq(age,97)) 250 0s N/A
- ORDER BY age ASC (鍐呭瓨鎺掑簭) 100 0s N/A sorted=true
- ORDER BY age DESC (鍐呭瓨鎺掑簭) 100 0s N/A sorted=true
- ORDER BY score ASC, age DESC (澶氬瓧娈? 10 9ms 1176
- GROUP BY age 鈫?COUNT(*) (娴佸紡 Scan) 80 0s N/A 80 groups
- GROUP BY age 鈫?AVG(score) (娴佸紡 Scan) 80 10ms 7983 80 groups
- UPDATE score=0 WHERE id>=1 AND id<=N/10 1,000 110ms 9073
- 楠岃瘉: score=0 鐨勮鏁? 1,009 10ms 100736
- UPDATE age=99 WHERE age=18 (浜岀骇绱㈠紩鏉′欢) 112 6ms 20273
- DELETE WHERE id>N*0.9 988 35ms 28592
- 楠岃瘉: 鍒犻櫎鍚庢€昏鏁? 9,012 0s N/A
- DELETE WHERE age=97 (浜岀骇绱㈠紩鏉′欢) 100 10ms 9988
- 鏈€缁? 鎬昏鏁? 8,912 4ms 2534843
- PK 鍒嗛〉: OFFSET N/2 LIMIT 10 10 7ms 1538 first_id=4989
- SEC 鍒嗛〉: OFFSET N/10 LIMIT 20 20 10ms 1995 first_age=19
- 鎬昏€楁椂: 2.375s
- 鏁版嵁搴撴枃浠跺ぇ灏? 1.6 MB
- === 鍩哄噯娴嬭瘯瀹屾垚 ===
|
