RE: PreparedStatement w/ Connection Pooling

2006-01-13 Thread George Sexton
> -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

Re: PreparedStatement w/ Connection Pooling

2006-01-13 Thread Marc Richards
; 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 > > > > > >

RE: PreparedStatement w/ Connection Pooling

2006-01-13 Thread GB Developer
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: > > &

Re: PreparedStatement w/ Connection Pooling

2006-01-13 Thread Khawaja Shams
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

RE: PreparedStatement w/ Connection Pooling

2006-01-13 Thread George Sexton
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

Re: PreparedStatement w/ Connection Pooling

2006-01-12 Thread Khawaja Shams
ed 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 Software, Inc. > >

RE: PreparedStatement w/ Connection Pooling

2006-01-12 Thread George Sexton
> Sent: Thursday, January 12, 2006 2:19 PM > To: Tomcat Users List > Subject: PreparedStatement w/ Connection Pooling > > Hello all, > I am working on a web application that will manage > assignments/students/classes for the teachers at a school. > Most of my page

RE: PreparedStatement w/ Connection Pooling

2006-01-12 Thread Marc Richards
> > From: Khawaja Shams [mailto:[EMAIL PROTECTED] > > Sent: Thursday, January 12, 2006 2:19 PM > > To: Tomcat Users List > > Subject: PreparedStatement w/ Connection Pooling > > > > Hello all, > > I am working on a web application that will > mana

RE: PreparedStatement w/ Connection Pooling

2006-01-12 Thread George Sexton
MH Software, Inc. http://www.mhsoftware.com/ Voice: 303 438 9585 > -Original Message- > From: Khawaja Shams [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 12, 2006 2:19 PM > To: Tomcat Users List > Subject: PreparedStatement w/ Connection Pooling > > Hello al

PreparedStatement w/ Connection Pooling

2006-01-12 Thread Khawaja Shams
Hello all, I am working on a web application that will manage assignments/students/classes for the teachers at a school. Most of my pages in the application need to access our mysql database very frequently. For this and for other security reason, I would like to use preparedStatements. Howev