You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@solr.apache.org by "Maulin (Jira)" <ji...@apache.org> on 2022/12/06 04:56:00 UTC

[jira] [Commented] (SOLR-16556) Solr stream expression: Implement Page Streaming Decorator to allow results to be displayed with pagination.

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

Maulin commented on SOLR-16556:
-------------------------------

Hi [~epugh]  

I have taken reading with a collection (order_details) which has got 1000000 records.

Below expression returns 10 records in 269 ms.  Here "{*}search{*}" stream source returns 100000 records and "page" decorator returns 10 records (starting from 1000 offset).


{code:java}
page(start=1000,rows=10,
search(order_details, q="product_id:[1 TO 100000]",qt="export",fl="id,qty",sort="id desc"),
sort=qty desc){code}

Performance of Page decorator depends on the number of records returned stream source ( similar to top  (RankStream) decorator).
If the number of records returned by "{*}search{*}" stream source is n[^Page Decorator Performance Reading.xlsx]ot too large, page decorator performance is good (like top decorator).

Please refer to the attached excel for more reading and server specs.

 

> Solr stream expression: Implement Page Streaming Decorator to allow results to be displayed with pagination.
> ------------------------------------------------------------------------------------------------------------
>
>                 Key: SOLR-16556
>                 URL: https://issues.apache.org/jira/browse/SOLR-16556
>             Project: Solr
>          Issue Type: Improvement
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: streaming expressions
>            Reporter: Maulin
>            Priority: Major
>              Labels: Streamingexpression, decorator, paging
>         Attachments: Page Decorator Performance Reading.xlsx
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Solr stream expression: Implement Page Streaming Decorator to allow results to be displayed with pagination.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org