Hello,
I’m facing a major issue with a simple query on a table that contains 140k items by default.
I’m doing a basic “Do a search for” with a constraint that returns 102k results.
Unfortunately, I can’t display or retrieve any data (not even the unique_id) from items beyond the 50k mark.
I tried querying using “item # from”, and even directly using “item #50001”… no results.
I tested “item # from 49999” and I do get 2 results.
Whether it’s on the backend or frontend: Bubble doesn’t seem to allow access to items beyond #50000.
What am I missing here?
I’ve tried many things to “bypass” what clearly looks like a hard limit on Bubble’s side… but nothing works — it just won’t go past 50000.
And just for context: there’s no sorting applied on my query, which I know normally limits to 50000 items.
Unfortunately it’s a limitation of bubble, I went through this in a database migration we did, to solve it, we took the records by season, I don’t know if for your case it would be like this, but you can do something similar, we put records for example from January to February, then March to April, thus fitting into the limit of 50 thousand items.
Thank you for your answer… unfortunately i can’t do this… i need to request all the item from 50k+1 until 50k (event 25k / 25k i don’t care)…
This is very very problematic…