phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alchemist <alchemistsrivast...@gmail.com>
Subject Re: Upsert is EXTREMELY slow
Date Wed, 11 Jul 2018 15:33:36 GMT
Thanks so much Josh!  I am unable to understand why performance is extremely
slow.  

1.  If I perform update using PreparedStatement addBatch and executeBatch
then I get nearly 6000 transactions per minute.

2.  But in our case we need to save each transaction so cannot perform
update batch,  so I am using PreparedStatement executeQuery and commit()
getting nearly 100 transactions per minute.

These numbers seems extremely slow,  therefore I am wondering I am doing
something very incorrect.



--
Sent from: http://apache-phoenix-user-list.1124778.n5.nabble.com/

Mime
View raw message