phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: Improve upsert performance - JDBC
Date Mon, 17 Mar 2014 16:53:53 GMT
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

Any reason why you can't turn auto commit off and commit in batches?


On Mon, Mar 17, 2014 at 5:39 AM, Manthosh Kumar T <>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

View raw message