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

[Wyatt Alt (JIRA)]

Title: Message Title

Wyatt Alt created an issue   PuppetDB / PDB-994 HSQL leaves some queries slow on large databases Issue Type: Bug Affects Versions: 2.2.2 Assignee: Unassigned Created: 22/Oct/14 5:32 PM Fix Versions: 2.2.x Priority: Normal Reporter: Wyatt Alt 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.github.com/wkalt/bfd5725c5709d05c6733 The postgres optimizer deals with this situation by rewriting the query with the where clause nested more deeply, but HSQLDB does not rewrite it. This ticket is to identify cases where this type of problem is surfaced and to deal with them as necessary. Add Comment   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.