phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva" <tdsi...@salesforce.com>
Subject Re: Phoenix Performance Improvement
Date Fri, 18 Jan 2019 00:22:48 GMT
Can you provide the schema of the table and the queries you are running?

On Tue, Jan 15, 2019 at 12:35 PM Azharuddin Shaikh <azharuddinshkh@gmail.com>
wrote:

> Thanks Pedro for your response.
>
> Actually we have an status column which consists of various status and we
> are executing queries which select queries which are fetching data from
> Hbase tables basis on status clause in the query and same is displayed on
> the application dashboard.
>
> An average daily ingestion is of 10k rows  to the existing table which is
> currently at 5M+.
>
> We had tried secondary index to avoid full scan on table but when queries
> are executed parallelly then timeout occurs after 30ms.
>
> It is working fine if we have only 1instance of an application running but
> if there are multiple application instances then we are experiencing
> timeouts.
>
>
> On Tue, 15 Jan, 2019, 9:47 PM Pedro Boado, <pboado@apache.org> wrote:
>
>> What type of queries are being thrown to the cluster? What's the average
>> row size? 5M rows seems a tiny table size.  30ms is OK for scans over a few
>> thousand records, but maybe not for full table scans.
>>
>

Mime
View raw message