[Opensource] Performance Question

[Michael Rimov]

At 09:14 AM 6/3/2002 +1000, you wrote:

>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.

Thanks to you and Larry for answering this question.  It makes sense since 
Prepared statements require an extra network round-trip to the database, 
but after all, the API documents can't be wrong in saying you get a 
significant performance boost, can they?  <grin>

The tasklist item talking about integrating PreparedStatement has now been 
removed from the list.

Thanks for everybody's feedback!
                                                 -Mike