Uploaded image for project: 'Apache Roller'
  1. Apache Roller
  2. ROL-2092

Optimizing the query that loads the comments in the Admin UI

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Abandoned
    • 5.1.2
    • None
    • None

    Description

      Listing comments in the admin UI seems useless due to terribly slow query in a Roller instance which has over ten thousands comments. Originally reported by Matt:
      http://mail-archives.apache.org/mod_mbox/roller-dev/201503.mbox/%3cCAFhCnT4HTH01ghKnTthiKPf3ALLfYT1UrqvzXeKm8A_y2bdtpg@mail.gmail.com%3e

      I think many unnecessary joins happen in it, So I believe it can be optimized a way without altering any of existing roller tables (I guess using NEW clause in the JPQL might help...).

      Anyway I wish I could see the result of EXPLAIN for the query...

      Attachments

        1. roller-slowquery.png
          363 kB
          Kohei Nozaki
        2. ROL-2092.patch
          1.0 kB
          Kohei Nozaki

        Activity

          People

            roller_unassigned Roller Unassigned
            xkylex Kohei Nozaki
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: