Hi Jeff, enhancement issue has been filed with https://bz.apache.org/bugzilla/show_bug.cgi?id=65515
It would be nice, if you could test the next nightly (https://jmeter.apache.org/nightly.html) or successful build from trunk and report back, whether it works for your use case. Felix Am 18.08.21 um 18:08 schrieb Jeff Lutzow: > Correction.... your suggestion to use that JSR223 Sampler with that Groovy > code works well and only does 1 Prepare followed by many Open, Fetch, Close, > Open, Fetch, Close....etc. > > Hi Jeff, > seems, that the prepared statements are not cached by default (and there is > currently no nice way to enable it via the GUI). > You can try to enable the prepared statements cache on the pool by using a > bit of JSR223 Groovy code: > ds = vars.getObject("AVZ1Server").configuredDataSource > log.info("ds.preparedStatements: {}", ds.poolPreparedStatements) > ds.poolPreparedStatements = true > ds.maxOpenPreparedStatements = 10 // adapt to your needs > log.info("ds.preparedStatements: {}", ds.poolPreparedStatements) > Add a JSR223 Sampler (use Groovy as language) before the first usage of the > connection and copy the above code to it. > Does that help? If so, you might want to open a bugzilla issue to add a flag > to enable prepared statement caching via the GUI. > Felix > > > Thanks very much for your help!!! > > I guess I should open a bug request like you suggested and have this added > into the JMeter GUI. > > Jeff > > -----Original Message----- > From: Felix Schumacher <[email protected]> > Sent: Wednesday, August 18, 2021 9:44 AM > To: Jeff Lutzow <[email protected]> > Subject: Re: FW: Have JMeter Prepare SQL ONLY once and Execute Multiple times > > EXTERNAL EMAIL > > > > > ================================ > Rocket Software, Inc. and subsidiaries ■ 77 Fourth Avenue, Waltham MA 02451 ■ > Main Office Toll Free Number: +1 855.577.4323 > Contact Customer Support: > https://my.rocketsoftware.com/RocketCommunity/RCEmailSupport > Unsubscribe from Marketing Messages/Manage Your Subscription Preferences - > http://www.rocketsoftware.com/manage-your-email-preferences > Privacy Policy - http://www.rocketsoftware.com/company/legal/privacy-policy > ================================ > > This communication and any attachments may contain confidential information > of Rocket Software, Inc. All unauthorized use, disclosure or distribution is > prohibited. If you are not the intended recipient, please notify Rocket > Software immediately and destroy all copies of this communication. Thank you.
OpenPGP_signature
Description: OpenPGP digital signature
