# What is the Best Practice for Data Relationships? **URL:** \ **Category:** Database\ **Created:** [April 18, 2021, 4:21pm UTC](https://forum.bubble.io/t/what-is-the-best-practice-for-data-relationships/146892 "2021-04-18T16:21:56Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![cmarchan](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/cmarchan/32/253062_2.png) [@cmarchan](https://forum.bubble.io/u/cmarchan)\ **Post date:** [April 18, 2021, 5:12pm UTC](https://forum.bubble.io/t/what-is-the-best-practice-for-data-relationships/146892/2 "2021-04-18T17:12:49Z")
In short, an indirect light dB structure is the way to go. List fields should be minimized and used for relationships of 100 entries tops. Here some interesting discussions: Great video by @duke.severn showing pros/cons on different structures [![](https://img.youtube.com/vi/PL_sOKcofw4/maxresdefault.jpg "Data architecture design in Bubble.is") ](https://www.youtube.com/watch?v=PL_sOKcofw4) Awesome case on the above initiated and substantiated by @lottemint.md > [@Alternative approach to the Bubble’s recent tutorials for list of things](http://forum.bubble.io/t/alternative-approach-to-the-bubble-s-recent-tutorials-for-list-of-things/88724): > > Hello everybody, I’ve taken a look at some tutorials from the following topic: In short, I think that these tutorials contain some crucial mistakes. Regarding How To Build A Pinterest Clone Without Code Configure your database User We’re facing this mistake on many apps. That’s a wrong approach since it negatively affects performance and speed. Let me explain why I do think that this is wrong. The Bubble’s unique id for each thing looks like the next one: 1583401182457x36677842… Best guide on building for performance (paid) by @petter > [@The Ultimate Guide to Bubble Performance - 156 pages of optimizing tips](http://forum.bubble.io/t/the-ultimate-guide-to-bubble-performance-156-pages-of-optimizing-tips/125918): > > Hey everyone, I’m very happy to announce that I’m releasing my book [The Ultimate Guide to Bubble Performance](https://gumroad.com/l/the-ultimate-guide-to-bubble-performance) today. [[image]](https://gumroad.com/l/the-ultimate-guide-to-bubble-performance) It’s a 156 page PDF available on Gumroad that dives deeply into the hard-earned lessons I’ve learned over five years of full-time Bubbling, focusing on: how to determine whether Bubble is the right tool for your project: the pros, cons and limitations from a performance perspective how to set up your app to load pages, process workflows and edit database records at ma… --- _[View the full topic](https://forum.bubble.io/t/what-is-the-best-practice-for-data-relationships/146892)._