Hello ! How one can make a query on typesense host...
# community-helpg
Gabriel Delattre
05/27/2025, 8:22 AMHello ! How one can make a query on typesense hosted to change the per page and get 100k records ? I just need the ids.
f
Fanis Tharropoulos
05/27/2025, 8:23 AMThe maximum number of results per page is
250👍 1
e
Elliot Sawyer
05/27/2025, 8:23 AMI think it returns 250 max per page, unless something changed recently
g
Gabriel Delattre
05/27/2025, 8:24 AMYes but I need more 🙂
e
Elliot Sawyer
05/27/2025, 8:24 AMIt'd be nice if it was configurable
Elliot Sawyer
05/27/2025, 8:25 AMI get the reasons for it, but always good to have an override
f
Fanis Tharropoulos
05/27/2025, 8:25 AMCan you give me your cluster's ID? We can override it for you.
e
Elliot Sawyer
05/27/2025, 8:27 AMThat's a huge benefit for hosted! Very good to know 👍
f
Fanis Tharropoulos
05/27/2025, 8:28 AMOn self-hosted, you can use the
max-per-page🚀 1
g
Gabriel Delattre
05/27/2025, 8:30 AMhey great
Gabriel Delattre
05/27/2025, 8:30 AMI know it could be not effective
Gabriel Delattre
05/27/2025, 8:31 AMbut we just need this for the following issue : https://typesense-community.slack.com/archives/C01P749MET0/p1748283329121419
Basically returning 100k records (30k is fine) per page, and only the ids would allow to clusterize client side
Gabriel Delattre
05/27/2025, 8:32 AMgfixplsrk0ab8w65pf
Fanis Tharropoulos
05/27/2025, 8:33 AMYou us to increase it to 100k?
g
Gabriel Delattre
05/27/2025, 8:33 AM50k will be ok
Gabriel Delattre
05/27/2025, 8:35 AMI guess I can then simply use
select Copy code
client.collections('books').documents().search({
query: 'harry potter',
select: 'title,author',
})f
Fanis Tharropoulos
05/27/2025, 8:36 AMJust changed it. For the changes to take effect, you'll need to initiate a rolling restart of your cluster. Go to your Cluster's configuration page, hit the Modify button, and schedule an update with no changes. When the restart is complete, the maximum number of results fetched per page will be 50k.
g
Gabriel Delattre
05/27/2025, 8:37 AMok testing !
Gabriel Delattre
05/27/2025, 8:37 AMthanks
🙌 1
Gabriel Delattre
05/27/2025, 8:42 AMrebooting in progress
Gabriel Delattre
05/27/2025, 8:51 AMin progress 🔄
Gabriel Delattre
05/27/2025, 9:10 AMhmm
Gabriel Delattre
05/27/2025, 9:10 AMimage.png
Gabriel Delattre
05/27/2025, 9:10 AMone node is keep
unhealthyf
Fanis Tharropoulos
05/27/2025, 9:12 AMIt will have to reindex the whole dataset before completing
g
Gabriel Delattre
05/27/2025, 9:23 AMok, still failing...
Gabriel Delattre
05/27/2025, 9:44 AMok, now it's
node 2f
Fanis Tharropoulos
05/27/2025, 12:05 PMIt was part of the rotational restart. It should be fine now
g
Gabriel Delattre
05/27/2025, 12:08 PMyes it is
f
Fanis Tharropoulos
05/27/2025, 12:09 PMAnd it should be returning 50k documents as well
g
Gabriel Delattre
05/28/2025, 8:36 AMit works !
Gabriel Delattre
05/28/2025, 8:37 AMthanks
🙌 1
Gabriel Delattre
05/28/2025, 10:27 AM@Fanis Tharropoulos could you please do the same for the following instance:
9wzbvihlrd2e0tg8pGabriel Delattre
05/28/2025, 10:27 AMthanks
f
Fanis Tharropoulos
05/29/2025, 10:51 AMI just initiated the restart
g
Gabriel Delattre
05/29/2025, 1:52 PMthanks