[ https://issues.apache.org/jira/browse/ROL-2092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kohei Nozaki updated ROL-2092: ------------------------------ Attachment: roller-slowquery.png > Optimizing the query that loads the comments in the Admin UI > ------------------------------------------------------------ > > Key: ROL-2092 > URL: https://issues.apache.org/jira/browse/ROL-2092 > Project: Apache Roller > Issue Type: Improvement > Components: Data Model & JPA Backend > Affects Versions: 5.1.2 > Reporter: Kohei Nozaki > Assignee: Roller Unassigned > Priority: Minor > Attachments: roller-slowquery.png > > > 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_y2bd...@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... -- This message was sent by Atlassian JIRA (v6.3.4#6332)