phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Riesland, Zack" <Zack.Riesl...@sensus.com>
Subject Multiple upserts via JDBC
Date Tue, 16 Feb 2016 16:10:52 GMT
I have a handful of VERY small phoenix tables (< 100 entries).

I wrote some javascript to interact with the tables via servlet + JDBC.

I can query the data almost instantaneously, but upserting is extremely slow - on the order
of tens of seconds to several minutes.

The main write operation does 10 upserts. Is there a better way to do this than 10 separate
statement.execute() commands?

Is there a way to pass all 10 at once?

Any tips on why these upserts might be so slow? I see that the tables are backed by one region,
so the overhead should be minimal.

Thanks!


Mime
View raw message