Hi all, posting a more general question here regarding relationships/lookups
I've been building apps in PowerApps using Sharepoint lists as a datasource. In the beginning I used lookUps in those sharepointlists to sort of help defining the relationships between tables (even tho it's not a relational database).
Of course I ran into trouble with those, especially with load times but also general patch issues and so on.
Took some advice from here and replaced all my lookup columns with just basic ID columns where I added the ID from Parent table and used that with lookups whitin powerapps to create collections. The result, was in many cases dramtically faster worker apps.
Im looking into Dataverse for teams now and I see that relationships between tables are defined using lookups.
Because of my horrible experience using LookUps whitin sharepoint im hestitant to use these.
So my question is, do the lookup relationships whitin Dataverse impact performance in PowerApps in a negative way like they do with sharepoint lists? Or are they just fine cause Dataverse is made to be able to handle these? Or should I just stick with my way of adding matching ID columns and not have any relationship at all?
New to dataverse and not by far an expert on relational databases
