search

txxxxc / isucon11-qualify

0 stars 0 forks source link

isu_conditionにindex追加 #6

Closed txxxxc closed 5 months ago

txxxxc commented 5 months ago

solve #3

やったこと

isu_conditionにインデックスを追加しました。その結果queryの速度を向上させることができました

before

#    1 0x8155B89FFD74A9D523D19AC4... 114.6834 48.3%   606 0.1892  0.07 SELECT isu_condition
#    2 0xDA556F9115773A1A99AA0165...  41.2035 17.4% 53510 0.0008  0.00 ADMIN PREPARE
#    3 0xFFFCA4D67EA0A788813031B8...  31.1264 13.1%  4814 0.0065  0.01 COMMIT
#    4 0xB8B32624C3268C0925657C30...  27.4380 11.6% 46227 0.0006  0.01 INSERT isu_condition
#    5 0x931A992E852C61FC6D46141A...  14.2199  6.0%   383 0.0371  0.15 SELECT isu_condition

after

#    1 0xFFFCA4D67EA0A788813031B8... 30.8256 28.1%  5103 0.0060  0.00 COMMIT
#    2 0xDA556F9115773A1A99AA0165... 29.0070 26.5% 56564 0.0005  0.00 ADMIN PREPARE
#    3 0xB8B32624C3268C0925657C30... 22.6585 20.7% 48552 0.0005  0.00 INSERT isu_condition
#    4 0x8155B89FFD74A9D523D19AC4... 18.3684 16.8%   974 0.0189  0.03 SELECT isu_condition
#    5 0x931A992E852C61FC6D46141A...  3.0735  2.8%   387 0.0079  0.04 SELECT isu_condition
#    6 0x1E561CE87F050ED58A7E1A7F...  1.8423  1.7%  4861 0.0004  0.00 SELECT isu