> can i use Callable Statement query type and provide all the select statements > in one jdbc sampler whose query type is Callable statement ? Yes, you can.
> I have done this and it is working fine. If so, definitely you can ;) > I have hundreds of select statements and i need to parameterise and correlate > them. Instead of using a jdbc sampler for each select statement I think you understand the main advantage of this approach: you can monitor execution time of each query and find problematic queries. As opposed to this, with multiple queries in one JDBC request you'll get execution time of all queries together. > Do the callable statement keeps a cache statement and then repeat the cache > statement again and again ? What is you database? For example, for Oracle caching of query plan is not subject of client but subject of database. Client just make it possible by using bound variables. If you are using script variables or variables substituted by '?' in JMeter, they will by bound variables. You can also check the text of queries using any tracing method. Only queries with the same text can have a their plan cached in DB. Unfortunately I'm not aware about other databases. ----- VR -----Original Message----- From: Jawaad Haider [mailto:[email protected]] Sent: Wednesday, June 18, 2014 2:47 PM To: [email protected] Subject: Using Callable statement Query type for multiple select , insert and update statements in a single jdbc sampler Hi, I came up with a scenario . I have hundreds of select statements and i need to parameterise and correlate them. Instead of using a jdbc sampler for each select statement(Very time consuming) can i use Callable Statement query type and provide all the select statements in one jdbc sampler whose query type is Callable statement ? Is this the best practice ? I have done this and it is working fine. Do the callable statement keeps a cache statement and then repeat the cache statement again and again ? is there anyother way to do this? --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
