Hi Zack, Have you tried to use sqlline to manually do those upserts to check the performance? Information about the tables structures would be useful as well.
Thanks, Sergey On Tue, Feb 16, 2016 at 8:10 AM, Riesland, Zack <zack.riesl...@sensus.com> wrote: > 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! > >
