> -Original Message-
> From: Khawaja Shams [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 13, 2006 2:44 PM
> To: Tomcat Users List
> Subject: Re: PreparedStatement w/ Connection Pooling
>
> Hello,
> Benchmarking is precisely what I am trying to do. H
; solution.
> >
> > Lord Kelvin said:
> >
> > "If you can not measure it, you can not improve
> it."
> >
> >
> > George Sexton
> > MH Software, Inc.
> > http://www.mhsoftware.com/
> > Voice: 303 438 9585
> >
> >
> >
hams [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, January 12, 2006 11:12 PM
> > > To: Tomcat Users List
> > > Subject: Re: PreparedStatement w/ Connection Pooling
> > >
> > > I am guessing the main attribute to change is the following:
> > &
9585
>
>
> > -Original Message-
> > From: Khawaja Shams [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, January 12, 2006 11:12 PM
> > To: Tomcat Users List
> > Subject: Re: PreparedStatement w/ Connection Pooling
> >
> > I am guessing the
Sent: Thursday, January 12, 2006 11:12 PM
> To: Tomcat Users List
> Subject: Re: PreparedStatement w/ Connection Pooling
>
> I am guessing the main attribute to change is the following:
> poolPreparedStatements="true"
>
> Suppose that this is set to true, how d
I am guessing the main attribute to change is the following:
poolPreparedStatements="true"
Suppose that this is set to true, how do I access these pooled statement? My
setup is exactly as you described, so this modification seems minor, but I
would appreciate guidance on how to get a hold of the
I would try testing it. I did some informal testing with SQL server and
found that it was MUCH less useful than everyone thought.
George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
> -Original Message-
> From: Khawaja Shams [mailto:[EMAIL PROTECTED]
> Sent:
If you're already using pooling then I imagine you
already have a resource defined for the pool in either
server.xml or in the context xml file. To pool
prepared statements, which is desireable, you should
configure it to look something like this in Tomcat
5.5:
Note that in this example I'
Generally speaking, if you were using most SQL databases the approach would
be to use a stored procedure. The stored procedure compilation saves the
various query plans as part of the data of the stored procedure. I doubt
MySQL does it, but you could ask on their development list.
George Sexton
MH
