Is there any better and optimized way to query a large datasets with interconnected relations instead of filtering and advance filtering.
And also what do you guys suggest for database structure which has DataTypes referenced to each other, a one way sync, two way sync or any other best practice?
Thanks!
I am sure everyone has their own opinion in this matter. To avoid advanced filtering, usually it is an adjustment of the data architecture that is required.
I try to make a database of items and have a ‘parent’ item attached to it. I typically stay away from adding a list of items onto a dataType.
Sometimes saving an extra value on a dataType can help save you from an advanced filter as well.
Does that make sense? 
It’s all about use case obv, but a general rule of thumb is that a 2 way sync doesn’t cost anything (assuming its not a list or its a small one) so if it helps for filtering (or even may down the road) go that route
