[ 
https://issues.apache.org/jira/browse/PHOENIX-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17003162#comment-17003162
 ] 

Lars Hofhansl commented on PHOENIX-5648:
----------------------------------------

Hmm... Is this the part where you have scanned a couple of rows on the "local" 
side and now you try to verify those rows on the "remote" side?

An IN query is translated into a SkipScan, and that's pretty optimal in the 
case above. I still don't buy that this will be net better.

When you refer to UngroupedAggregatedRegionObserver, do you mean a local one or 
the remote cluster side?

My apologies if I'm missing some context here.

> Improve IndexScrutinyTool's performance by moving comparison logic to server 
> side
> ---------------------------------------------------------------------------------
>
>                 Key: PHOENIX-5648
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5648
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 5.0.0, 4.15.0, 4.14.3
>            Reporter: Swaroopa Kadam
>            Assignee: Swaroopa Kadam
>            Priority: Minor
>             Fix For: 4.15.1, 4.14.4
>
>
> If IndexScrutinyTool runs on a table with billion rows, it takes lots of 
> time. 
> One of the ways to improve the tool is to move the comparison to the 
> server-side. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to