phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Phoenix table stats query performance issue
Date Sat, 12 Dec 2015 05:51:12 GMT
Hi Li,
That's not performance degradation. Your query requires a full table scan
to calculate the row count. It's going to get slower as the table grows.
Your new queries will remain fast as the table grows in size.
Thanks,
James


On Fri, Dec 11, 2015 at 7:46 PM, Li Gao <gaol@marinsoftware.com> wrote:

> Hi Phoenix community,
>
> We are encountering general performance degradation when doing table stats
> query over the leading primary key column in a Phoenix table.
>
> The table schema, used query, JMeter results observed over 1-hour window,
> and the python script that slowly generate data into the table.
>
> Please advise how we can improve the performance of the query
>
> Thanks,
> Li
>
>

Mime
View raw message