phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Naveen Nahata <nahata.ii...@gmail.com>
Subject Phoenix Performance issue
Date Tue, 10 May 2016 19:57:36 GMT
Hi,

I am using phoenix 4.5.2-HBase-0.98 to connect HBase. To benchmark phoenix
perforance executed select statement on primary key using phoenix driver
and hbase client.

Surprisingly figured out PhoenixDriver is approx. 10~15 times slower then
hbase client.


​
Addition to this looked explain statement from phoenix, which stats query
is look up on one key.



​
If query on look up on 1 key why its taking so long ?

Code Ref.

// Connecting phoenix

String sql = "select * from fklogistics.shipment where shipmentId =
'WSRR4271782117'";
long startTime = System.nanoTime();
ResultSet rs1 = st.executeQuery(sql);
long endTime = System.nanoTime();
long duration = endTime - startTime;
System.out.println("Time take by phoenix :" + duration);

// Connecting HBase

Get get = new Get(row);
startTime = System.nanoTime();
Result rs = table1.get(get);
endTime = System.nanoTime();
duration = endTime - startTime;
System.out.println("Time take by hbase :" + duration);

Please suggest why query is so slow ? Also will upgrading phoenix
driver can help in this ?

Thanks & Regards,

Naveen Nahata

Mime
View raw message