Does searching against double nested child reduce performance?

[giosegar]

I have an outfit image which has a data field with a list of outfit pieces, which in turn have data fields that tie them to another data type. I want to search against that third level to return a list of outfit images. I noticed that when I do this, it’s pretty slow. My question is if searching against nested children is slower. Should I move that third level of data up directly under the outfit image to improve search performance?

[cmarchan]

If your dB consists of many list fields and if these lists go beyond 100 entries … yes

If you want to go up the ladder from a third level up via parent objects that have many list fields … yes

Consider exploring the following resource (paid) that explains this and other aspects about how to build for performance:

The Ultimate Guide to Bubble Performance - 156 pages of optimizing tips

Hey everyone, I’m very happy to announce that I’m releasing my book The Ultimate Guide to Bubble Performance today. [image] 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…

[giosegar]

Thanks for the response. I figured out a way to avoid an advanced filter “contains list” search, which fixed my performance issue. I’ll definitely keep that guide bookmarked in case I run into another performance issue!