I’m wondering what’s best in terms of performance: having less DB entries (lines) and using “list fields”, or just creating more entries? For example: A) When a user completes a task, write TaskId inside the CompletedTasks list field inside SomeEntry of SomeTable. B) When a user completes a task,…

[image] luuustuuucruuu: just creating more entries? This one

Welcome back to the community @luuustuuucruuu ! Using lists is certainly better for performance. However, as the app scales these make the entries heavier and this slows down the app. Flat data types scale better. Having said this … many MVPs focus on doing one thing great. Once the concept has ga…

[image] luuustuuucruuu: I’m wondering what’s best in terms of performance: having less DB entries (lines) and using “list fields”, or just creating more entries? It depends entirely on what you mean by ‘performance’… In terms of what is faster to load, lists have always been, and still are, …

Hey @adamhholmes Wise advice!!! I opted to suggest lists because most projects if approached as simple MVPs end up being rebuilt. You are absolutely right though. Just looking at an app … and planning all aspects of it … I agree 100% that flat objects scale significantly better. On another note:…

[image] cmarchan: I opted to suggest lists because most projects if approached as simple MVPs end up being rebuilt. I agree… the truth is, in most cases, even using lists ineffectively/inefficiently probably won’t cause that much of an issue at small scale. [image] cmarchan: On another n…

[image] adamhholmes: That’s correct, there is a hard limit in Bubble of 10k items for list fields. I thought that was the case, too, but I was recently told otherwise .

Thanks Gentlemen @adamhholmes @mikeloc for chiming in! Just checked the Bubble docs … which by the way … have improved substantially I should say and they do indicate a hard limit of 10k Just fyi which I know is nothing new to neither one of you :wink: Thanks again! [screenshot-manual.bubble.io…

[image] mikeloc: I thought that was the case, too, but I was recently told otherwise . My own testing (just now) still shows 10k as the hard limit for adding items to list fields: [image] (in fact, it seems the limit is actually 9999… trying to add one more item to a list that already has …

With all due respect to Keith, I didn’t necessarily think he was right (although, he did say he tested it), but I honestly didn’t care because I would never use a list field to hold more than a couple hundred items.

Yeah… exactly… whether it’s 10k, 100k, or a million, it’s hardly important… as the real practical limit is much much lower, and for most reasonable use-cases lists are going to be used for 10s or 100s items… not thousands. note: the limit of 10k list items only applies to database list fields… not …

Better performance: less entries and more lists, or more entries and no lists?

Questions

mikeloc January 2, 2024, 2:53pm 7

I thought that was the case, too, but I was recently told otherwise.

Topic		Replies	Views
How does bubble's DB actually function with list fields Database	2	1408	June 8, 2022
Creating a list longer than 10.000 records Database	9	2446	November 5, 2022
Race Conditions: Beware of Using List Fields in Objects If You Plan To Scale Bugs	14	6961	October 8, 2023
Max count in a List Need help	7	583	December 22, 2023
Database Read/Write INCREDIBLY SLOW Need help	34	5767	April 9, 2019

Better performance: less entries and more lists, or more entries and no lists?

Related topics