Jira (PDB-994) HSQL leaves some queries slow on large databases

[Kenneth Barber (JIRA)]

Title: Message Title

Kenneth Barber commented on an issue   Re: HSQL leaves some queries slow on large databases Wyatt Alt are we actually committing to fixing this in 2.2.x? If not best to leave the fix version blank. Add Comment   PuppetDB / PDB-994 HSQL leaves some queries slow on large databases The export process is very slow on HSQL when large numbers of reports and events are involved. The query generated by our events-for-report-hash function in export.clj is affected. The bad query is here: https://gist.github.com/wkalt/d09b7bb0b4a2908018de it is made good by moving the final where clause one set of parentheses inward: https://gist.... This message was sent by Atlassian JIRA (v6.1.4#6159-sha1:44eaede) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.