sugarcrm-developers / school

Professor M's School for Gifted Coders
Apache License 2.0
20 stars 19 forks source link

Create example query that uses large number of relationships #75

Open lschaefer-sugarcrm opened 6 years ago

lschaefer-sugarcrm commented 6 years ago

Create an example that addresses https://www.sugarcentral.sugarcrm.com/message/14292?commentID=14292&et=watches.email.thread#comment-14292.

From @mmarum-sugarcrm: This is a use case we should consider adding to Professor M once we’ve achieved resolution here.

Basically, we’re hitting a JOIN limit when a large number of relationships exist. This is relatively common, especially when there are lots of custom modules, so we should consider how many we want to add. In particular, is there a hard limit we should consider.