phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: Slow query on Secondary Index
Date Tue, 18 Sep 2018 20:06:12 GMT
To better understand the problem, we may require your DDL for both the
indexes and data table and also the query using your secondary index
And,  please try some tuning documented on
https://phoenix.apache.org/secondary_indexing.html and see if it helps.


On Tue, Sep 18, 2018 at 11:25 AM Josh Elser <elserj@apache.org> wrote:

> Your question is suitable for the user@phoenix mailing list. Please do
> not cross post questions to multiple lists.
>
> On 9/18/18 10:57 AM, Vishwajeet Rana wrote:
> > Hi,
> >
> > I have two salted global secondary indexes (A and B) on a table with row
> > key (primary key) as the covered column. For both of them, the read
> > single row latency is fine with less QPS, but as QPS increases from the
> > client side, query on one of the indexes (A) becomes 10x slow, while the
> > other (B) remain unaffected. Also, I have noticed that the transmitted
> > bytes in the hbase region server increase drastically while querying on
> > index A. Can you explain this behaviour?
> >
> > Thanks,
> > Vishwajeet
>

Mime
View raw message