Bubble reference is saying that “Currently, lists are limited to 10,000 items”. Can an app have more than 10000 things of the same type in its database? If yes, what happens with queries/searches which produce lists if this limitation is reached?

I think so too! Here is the original post from Josh with more information: [image] Limitations running workflows on a list Need help Hey Alex, Thanks for the clear, well-structured question. Couple things to note upfront: The main limit with big list operations right …

Hey @eftomi :slight_smile: Yes there can be more than 10,000 things of the same type in the database. The 10,000 limit is on fields that store a list of Things. For example, if you had a data type called “Projects”, and stored a list of Projects on the User data type (“Projects”, type: Project, li…

Great, I see the difference, thanks! I suppose this goes also for lists as custom states. In Bubble’s reference the limitation is mentioned under the general title “Data operations and comparisons”. What happens if you get a list of items as a result of Search, which is over 10.000? Or when you use…

No problem! :slight_smile: This may have changed, but from the last posts I read on this, if you’re displaying results from a search, the limit is 50,000 (I believe this is different if you’re on a dedicated plan). If the number of results is over 50,000, nothing will happen, but only the first 50,…

OK - I have a couple of tables which are >80,000, but these are ‘joining’ tables and are not meant to be displayed directly, so Bubble will have to handle them only “virtually” within expressions. The final results of expressions will be lists of the usual, small size. So I suppose it will work.

Excellent, thanks! [edit:] I tested a table with >10,000 things, Search for Things {fieldX=yes} :count and it works.

Are any of you experiencing performance problems as your DB grows? My app is now just shy of about 1,000 users, but I’m starting to note significant sluggishness when querying the DB - specifically pulling back items on the page that rely upon querying User “thing” information (e.g. profile picture…

Hello @ezmaass – I’m just getting started but definitely need to know if this is an issue I’ll face down the road as we are close to landing some clients that will really affect usage. Did you find a solution for this? Thanks!!

Db limitations?

Need help Database

fayewatson November 8, 2017, 9:19am 6

I think so too! Here is the original post from Josh with more information:

Topic		Replies	Views
Database record limit Database	12	6502	November 22, 2022
Limit to the number of items in an array/bubble List? Database	4	2472	June 14, 2022
List of things 1k or 10k? Questions	2	1473	November 20, 2016
How much data can we input to my Database Questions	5	2218	December 10, 2024
Max count in a List Need help	7	609	December 22, 2023

Db limitations?

Related topics