#community-help

Discussing Typesense 250 Items Per Page Limit and Possible Solutions

TLDR Bruno had concerns about Typesense's 250 items per page limit affecting data retrieval and table pivoting. Jason confirmed the limit application occurs after grouping and suggested multi-search as a workaround.

Powered by Struct AI
+11
6
25mo
Solved
Join the chat
Aug 05, 2021 (25 months ago)
Bruno
Photo of md5-0ca37054c6c9042aa04fcfb92cc7d99c
Bruno
05:05 PM
Our use case scenario is basically one big table, that we intend to pivot on some fields. However, the 250 items per page limit has me concerned. For some searches, not all results will be retrieved, a problem made worse by the fact that pivoting the table further reduces the number of actual rows. I've tried to leverage the groupBy function to work around this issue, but now I have a question: are the 250 results max counted before the grouping, or after? If it's after the grouping, then I'll be fine, as 250 results = 250 table rows. If it's before, though, then for example 250 results might be 150 table rows.
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
05:17 PM
> are the 250 results max counted before the grouping, or after?
It's counted after.
Bruno
Photo of md5-0ca37054c6c9042aa04fcfb92cc7d99c
Bruno
05:20 PM
Ok, I'll give this a shot, thanks.
05:21
Bruno
05:21 PM
By the way, (a) are there plans to increase the 250 item limit on pages? (b) could I leverage multisearch to grab like 3 or 4 pages at once?
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
05:28 PM
There are no current plans to increase the 250 per page limit due to performance considerations, since we specifically optimize for perf in Typesense.

Yes, you can use multisearch to grab multiple pages. Multi-search is just independent search queries that are wrapped in one HTTP call
Bruno
Photo of md5-0ca37054c6c9042aa04fcfb92cc7d99c
Bruno
05:28 PM
Ok, thanks again!
+11