Hi Manthosh, Probably not a lot you can do. If it's the same upsert statement, you can cache the PreparedStatement to avoid the parse cost (but I doubt that'll help).
Any reason why you can't turn auto commit off and commit in batches? Thanks, James On Mon, Mar 17, 2014 at 5:39 AM, Manthosh Kumar T <[email protected]>wrote: > Hi All, > Currently when I upsert values via JDBC, each upsertion takes > 14-20 ms on an average. Auto commit is set to true. Is there a way to > improve this without batch insert?. > > -- > Cheers, > Manthosh Kumar. T >
