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/

Reply via email to