Re: Is first query to a table region way slower?

2018-01-28 Thread James Taylor
Did you do an rs.next() on the first query? Sounds related to HConnection establishment. Also, least expensive query is SELECT 1 FROM T LIIMIT 1. Thanks, James On Sun, Jan 28, 2018 at 5:39 PM Pedro Boado wrote: > Hi all, > > I'm running into issues with a java springboot

Is first query to a table region way slower?

2018-01-28 Thread Pedro Boado
Hi all, I'm running into issues with a java springboot app that ends up querying a Phoenix cluster (from out of the cluster) through the non-thin client. Basically this application has a high latency - around 2 to 4 seconds - for the first query per primary key to each region of a table with