phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
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
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 <manthosh@gmail.com>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
>

Mime
View raw message