Upgrade to Pro — share decks privately, control downloads, hide ads and more …

MySQLでタグ検索

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
Avatar for T. MOTOOKA T. MOTOOKA
October 23, 2014

 MySQLでタグ検索

2014.10.23(木) MySQL勉強会 in 大阪 LT
タグ件数10^5〜10^6程度のタグ検索の仕組みをMySQLで組んでみた話

Avatar for T. MOTOOKA

T. MOTOOKA

October 23, 2014
Tweet

More Decks by T. MOTOOKA

Other Decks in Technology

Transcript

  1. ࣗݾ঺հ ຊԬ ஧ٱʢ @t_motooka / id:t_motookaʣ Web ΞϓϦ։ൃ iOS ΞϓϦ։ൃ

    ςΫχΧϧΤϯδχΞʢσʔλϕʔεʣ
 ʢݱɿσʔλϕʔεεϖγϟϦετʣ
  2. ߟ͑ͨ݁Ռ ॏෳআڈͨ͠λάͷٙࣅ Materialized View Λ༻ҙʢ4ສ݅ʣ
 ɹˠ ͜͜Ͱ͸ full table scan

    ͦͷ݁ՌΛ engine=memory ͳҰ࣌දʹಥͬࠐΉ
 ˞֤λάͷҰக౓߹͍ΛείΞԽʢޙͰ order by Ͱ࢖͏ʣ ͦ͜ͱλάදΛjoinʢͪΌΜͱ index ࢖ͬͯ͘ΕΔʣ ͳΜͱ͔࣮༻ʹ଱͑ΔϨϕϧ
  3. ׬