[PHOENIX-1170] Change status of local index during splitting to prevent usage when slower than query through data table

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.2.0
• Assignee: rajeshbabu
• Reporter: James R. Taylor
• Created: 14/Aug/14 17:25
• Updated: 21/Nov/15 02:16
• Resolved: 27/Oct/14 21:32

Description

Without pre-split, queries to the table take 9x more time (i.e. 1 sec versus 9sec) for a count. If we can't bring the time down to be less than a full scan over the data table, we should update the local index status as INACTIVE while it's splitting, then it wouldn't be used for queries, but it would continue to be maintained. Then when the split is done, we could move it back to ACTIVE. Alternatively, we could invent a new status, like SPLITTING, and only use the local index for point lookups until the status is back to ACTIVE.