Re: 3.1.7 Not Using Server-Side Prep Stmt?
Posted by: Jason Winnebeck
Date: February 25, 2005 01:31PM

I'll give you a more in-depth response on Monday as I don't have the code with me now, but our queries are in the form "SELECT a, b, c FROM T1 WHERE X UNION SELECT a, b, c FROM T2 WHERE X" where X is some where statement on primary key. T1 and T2 have the same table definition. We used to prepare all statements whent he program starts, now we have a statement cache and we "lazily"prepare on first use as we don't always use all prep stmts. We use the same code for SQL Server JDBC which has a very long prepare time so we are aware of how to use them correctly -- prep once, execute many.

3.0.11 works identically in performance to 3.1.6 and 3.1.7 with default settings. Setting emulatePS to off in 3.1.7 results in a 30% speedup.

Jason Winnebeck
Center for Integrated Manufacturing Studies
Rochester Institute of Technology, Rochester NY

Options: ReplyQuote


Subject
Written By
Posted
Re: 3.1.7 Not Using Server-Side Prep Stmt?
February 25, 2005 01:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.