[jira] [Commented] (PHOENIX-1267) Set scan.setSmall(true) when appropriate

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-1267:
---------------------------------------

FYI, both PHOENIX-3073 and PHOENIX-3906 have useful information on this one.

I think a good first step would be to automatically make point lookup queries small scans when the number of rows returned is less than a configurable threshold (see attached WIP patch). Certainly if we're returning a single row, a small scan will be much better (according to above JIRAs, 50% better). We could start with a configuration of 100 perhaps? Also, the configuration parameter could be set to zero which would essentially disable this feature which is a good thing.

[~Misraji] - this would be a good one for you to start with IMHO.




> Set scan.setSmall(true) when appropriate
> ----------------------------------------
>
>                 Key: PHOENIX-1267
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1267
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>              Labels: SFDC
>             Fix For: 4.12.0
>
>         Attachments: smallscan2.patch, smallscan3.patch, smallscan.patch
>
>
> There's a nice optimization that has been in HBase for a while now to set a scan as "small". This prevents extra RPC calls, I believe. We should add a hint for queries that forces it to be set/not set, and make our best guess on when it should default to true.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)