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