[Opensource] Performance Question

[Johnson Tong]

preparestatement is bad that has create many connection that out of control
of
connection pool, as a result, after a few days of your web site launch, you
server
will crash.I have thousands of connection with the database that has not
close.
even no users is using this for a long time, those connection is a by
product of 
prepare statement.
it may get a little improvement but not a big deal, compare with the
reliable issus,
that is bad.


-----Original Message-----
From: Michael Rimov [mailto:rimovm at centercomp.com]
Sent: Sunday, 2 June 2002 7:09 AM
To: opensource at jcorporate.com
Subject: [Opensource] Performance Question


Hey All,

I was wondering if somebody had some stats on something.  Many people have 
been requesting prepared statements for performance reasons.  As far as 
Expresso's DBConnection works, I'm not sure how much use it would be since 
prepared statements are dependant on a single connection and the point of 
DBConnection/DBConnectionPool is releasing the connection as soon as you're 
through.

I've read that supposedly some databases will cache the query plan and thus 
you could get some performance improvements that way.  But what I'm 
wondering is... does anybody have any real experience with this and any 
empirical data to show that this really is a performance booster? 
[Especially when used in conjunction with a Connection Pool, JNDI or
otherwise]

Any citations would be greatly appreciated.

Thanks in advance!
						-Mike

_______________________________________________
Opensource mailing list
Opensource at jcorporate.com
http://mail.jcorporate.com/mailman/listinfo/opensource
Archives: http://mail.jcorporate.com/pipermail/opensource/


_______________________________________

This Email has been scanned by MIMEsweeper
_______________________________________


<FONT SIZE=1 FACE="ARIAL" > 
<p>_____________________________________________________________________________

This e-mail (and any attachment) is intended only for the addressee and
may contain confidential information.  If you are not the intended recipient
you must not use, copy, print or distribute this e-mail. If you receive this
e-mail in error, please contact the sender and destroy the original.</p>
<p>This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
_____________________________________________________________________________</p>
</FONT>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20020603/bc872c38/attachment-0002.htm