[jira] [Updated] (PHOENIX-1428) Keep scanner open on server and pace by client instead of spooling

["Samarth Jain (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Samarth Jain updated PHOENIX-1428:
----------------------------------
    Attachment: PHOENIX-1428.patch

Patch to conditionally use spooling and chunking iterators for non-aggregate queries. Existing tests pass.

[~jamestaylor] - please review.

> Keep scanner open on server and pace by client instead of spooling
> ------------------------------------------------------------------
>
>                 Key: PHOENIX-1428
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1428
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Samarth Jain
>              Labels: SFDC
>         Attachments: PHOENIX-1428.patch
>
>
> Instead of spooling a batch of results for all chunked scans to the client, keep the scan open and pace it through pre-fetching. This will perform much better for a full table scan with a LIMIT = 1, as this case currently will run a scan for every guidepost, each returning a single row.
> [~lhofhansl]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)