[Opensource] Performance Question

[larry hamel]

here's an excerpt from an oreilly text on this, at least regarding oracle:

http://www.oreilly.com/catalog/jorajdbc/chapter/ch19.html

>When you consider typical SQL statement usage, even with the Thin driver, you'll get better performance if you execute your SQL statements using a Statement object instead of a PreparedStatement object. 


the excerpt includes some performance graphs to back up their claims.

larry

At 02:09 PM 6/1/2002, Michael Rimov wrote:
>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/