phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <>
Subject [jira] [Resolved] (PHOENIX-1200) Delay setting local index active until usable
Date Tue, 02 Sep 2014 15:54:21 GMT


James Taylor resolved PHOENIX-1200.
    Resolution: Duplicate

Duplicate of PHOENIX-1170

> Delay setting local index active until usable
> ---------------------------------------------
>                 Key: PHOENIX-1200
>                 URL:
>             Project: Phoenix
>          Issue Type: Sub-task
>    Affects Versions: 4.1
>            Reporter: James Taylor
>            Assignee: rajeshbabu
> The performance of a local index immediately after it is built is terrible. Instead of
taking 1 second over a count(*) query, it takes 9 seconds. This is an order of magnitude worse
than a full scan over the data table. After some period of time, the performance is good.
> We should delay setting the local index as active until after whatever is going on finishes
to prevent the local index from being used while it's so slow. First we need to figure out
what HBase is doing at this point.

This message was sent by Atlassian JIRA

View raw message