phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alchemist <>
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

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:

View raw message