SELECT c FROM WeblogEntryComment c WHERE c.weblogEntry.website = ?1 ORDER BY c.postTime DESC
Could experiment with some indexes..... or add websiteid to the roller_comment so it does not have to do the join with weblogEntry to get the website parameter #1. The websiteid does not change. On 2 March 2015 at 19:29, Matt Raible <m...@raibledesigns.com> wrote: > Is it possible to optimize the query that loads the comments in the Admin > UI? When I click on the "comments" section (in the Admin UI), it takes a > really long time to load and I sometimes see the following error. The > sysadmin at my ISP (kgbinternet.com) said this SQL takes a long time to > run > and is sometimes killed by the server. > > > https://drive.google.com/file/d/0B9kkDCT2WDMXNE9XZl9LSXVHbmVjeklyVnBGNm9jd3p4R0gw/view?usp=sharing > > My blog has 3193 entries and 13,799 comments (since 2002). > > Thanks, > > Matt > > On Sun, Mar 1, 2015 at 6:04 PM, Kohei Nozaki <k...@bridge9.sakura.ne.jp> > wrote: > > > Sorry I just found a problem to my patch which accepted in > > https://issues.apache.org/jira/browse/ROL-2063 . could you take a look > at > > my new patch ROL-2063_update1.patch and comment in that JIRA? > > > > ROL-2063_update1.patch > > > > > > On Mar 2, 2015, at 4:56, Dave <snoopd...@gmail.com> wrote: > > > > > Hi Roller fans, > > > > > > I would like to propose that we release Roller 5.1.2 based on the code > at > > > Subversion tag roller_5.1.2-rc1. You can download the source release, > > > convenience binaries and signatures for the release here: > > > > > > https://dist.apache.org/repos/dist/dev/roller/roller-5.1/v5.1.2/ > > > > > > The release contains a variety of mostly minor fixes which you can find > > > listed here: > > > > > > > > > https://issues.apache.org/jira/issues/?jql=project%20%3D%20ROL%20AND%20fixVersion%20%3D%205.1.2%20AND%20updated%20%3E%3D%20-20w%20ORDER%20BY%20updated%20DESC > > > > > > Please vote within the next 72 hours. > > > > > > I'm voting +1 > > > > > > Thanks, > > > Dave > > > > >