1. 19 Aug, 2021 1 commit
    • Evangelos Foutras's avatar
      Use custom index to speed up searches with many results · 411f2f32
      Evangelos Foutras authored
      Use the custom (id, topic_id, posted) index on fluxbb_posts to speed up
      searches that return a lot of results. I also added the posted field to
      the predefined posts_multi_idx index so the "show_user_posts" action is
      fast too.
      
      On a related note, a key component of fast searching was to reorder the
      fluxbb_search_matches table by the word_id column. This table has a lot
      of rows (~73 million) and we want to be able to filter based on word_id
      and quickly get the respective post ids. Previously it had to seek over
      a couple of GBs to fetch the post ids. Ordering by word_id allows us to
      get a (word_id, post_id) index for free (would take ~2GB to create it).
      411f2f32
  2. 15 Aug, 2021 1 commit
  3. 26 Jan, 2021 2 commits
  4. 24 Jan, 2021 2 commits
  5. 23 Jan, 2021 2 commits
  6. 06 Jan, 2021 1 commit
  7. 02 Jan, 2021 16 commits
  8. 01 Sep, 2019 2 commits
  9. 10 Feb, 2019 3 commits
  10. 07 Jan, 2019 1 commit
  11. 15 Aug, 2018 3 commits
  12. 30 Dec, 2017 1 commit
  13. 07 Dec, 2017 1 commit
  14. 30 Aug, 2017 4 commits