Jira (PDB-470) Investigate and implement setStatementsCacheSize for repetitive SQL performance

[Kenneth Barber (JIRA)]

Title: Message Title

Kenneth Barber commented on an issue   Re: Investigate and implement setStatementsCacheSize for repetitive SQL performance PR is here: https://github.com/puppetlabs/puppetdb/pull/874 Add Comment   PuppetDB / PDB-470 Investigate and implement setStatementsCacheSize for repetitive SQL performance It seems the setting setStatementsCacheSize for BoneCPConfig will enable prepared statements cache. This seems to have a great effect on our insert time, especially at high load. So far I've tested this 3 times and found that the number of seconds spent doing inserts is almost halved. The proposal is to implement this setting as a user configurab... 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/groups/opt_out.