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!
