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 <g...@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 > >
