Josh Elser-2 wrote > Josh thanks so much for all your help. I do not understand why you > "However, you are still fighting yourself when you have threads all trying > to grab the same lock to write their data." My understanding is if we > have many processes running many threads, the data will be logged into WAL > as they come then flushed to the disk. Where is the contention in this > case? Do we have one write per region/region server? > > > > On 7/11/18 11:33 AM, alchemist wrote: >> 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/ >>
-- Sent from: http://apache-phoenix-user-list.1124778.n5.nabble.com/