Why are reverse relationships bad?
Somebody mentioned to me that I have a lot of reverse relationships. I read somewhere they are bad, but I have not found a reason. Can anyone elaborate? Our app has reverse relationships to act a...
Forum Discussion
Yeah, I have a great many tables in my app (73) and numerous reverse relationships throughout, and several tables that have hundreds of thousands of records. Overall, I think a bigger performance killer is simply not being smart about ordering your report filters correctly and not being smart about what embedded reports and charts you put on forms that get loaded frequently.
I have not received permissions to go live with the app yet so I haven't had it tested to extremes, though we are much smaller than your app it sounds like (25 tables and currently <1200 projects).
I would be curious to learn what situations are slowing you down though, if you would be willing to talk. I just would like to see what types of charts are slowing you down and how much/ / from where the data is coming, 1, 2, many tables etc.
I would be curious to learn what situations are slowing you down though, if you would be willing to talk. I just would like to see what types of charts are slowing you down and how much/ / from where the data is coming, 1, 2, many tables etc.