Re: JDBC / Oracle / MS SQL Server performance anomalies

Well to improve performace using dynamic sql you have to set this instance parameter

cursor_sharing='FORCE'

using that i got 86secs on a notebook with a celeron 700Mhz with oracle 9i JvM 1.3.1

if cursor_sharing='EXACT' i get 156secs.

so you are getting rougly a 100% performance increase. Anyway using batch update and prepared statement it takes 7-10secs :)

I guess you can further improve performance with a deeper tuning.

hope this help

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG