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

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

Hi [~jbernste]

Thanks for your feedback. I looked at 
[https://solr.apache.org/guide/8_11/transform.html#paging]. Paging can be 
implemented with this stream function.

However In my experiment, performance of *PagingStream*  seems much better 
compared to {*}stream functions (recNum gt, lt){*}.

e.g. *StreamFunction approach took 1872 ms.* 
{code:java}
having(
     select(
     search(order_details, q="product_id:[1 TO 
1000000]",qt="/export",fl="id,qty",sort="qty desc"),
     id,
     qty,
     recNum() as recNum),
     and (gt(recNum, 0),lt(recNum, 11))
){code}
where *Paging Stream took 1044 ms*
{code:java}
page(start=1,rows=10,
search(order_details, q="product_id:[1 TO 
1000000]",qt="/export",fl="id,qty",sort="qty desc"),
sort=qty desc){code}

> 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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to