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] [Comment Edited] (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 edited comment on SOLR-16556 at 12/6/22 4:55 AM:
--------------------------------------------------------
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 not too large, page decorator performance is good (like top decorator).
Please refer to the attached excel for more reading and server specs.
[^Page Decorator Performance Reading.xlsx]
was (Author: mnrathod):
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