1. 08 May, 2020 1 commit
  2. 13 Feb, 2020 2 commits
  3. 11 Oct, 2019 1 commit
  4. 24 Apr, 2019 6 commits
  5. 01 Mar, 2019 1 commit
  6. 25 Feb, 2019 5 commits
  7. 14 Jan, 2019 5 commits
  8. 28 Sep, 2018 1 commit
  9. 23 Sep, 2018 6 commits
  10. 22 Feb, 2018 1 commit
  11. 19 Sep, 2017 3 commits
  12. 18 Sep, 2017 2 commits
  13. 27 Jan, 2017 1 commit
  14. 19 Jan, 2017 1 commit
    • Mikael Salson's avatar
      ModeleRepository: Rewrite query for popular models · bc509d47
      Mikael Salson authored
      The previous query was very slow (~8s on the production server) because
      of a misconception issue. The query is now rewritten with GROUP BY and
      COUNTS. This avoids counting separately for every result.
      This also allows to merge the results more efficiently and avoids
      to have a cartesian product (as previously).
      
      However DQL doesn't seem to support subqueries (not sure about that)
      so the query is written in pure SQL. Therefore the results do not contain
      objects and we need to have additional queries in order to get objects as previously.
      bc509d47
  15. 17 Oct, 2016 2 commits
  16. 07 Sep, 2016 2 commits