Phoenix Performance issue

[Naveen Nahata <na...@gmail.com>]

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