Is there a known limit to number of joins?
Feb 14, 2011
A portion of my application provides a list view. For this view, I need related info from many tables. The query isn't all that complex, but it does join all the tables. I have experienced that joining a few tables works fine. When I get up to 5 or 6 tables, the procedure won't even compile. Memory is used up very quickly and fails with a heap error (tried as much as 1GB heap for java). (Playing with the query in adhoc mode results in a similar result - a few joins work, at 5 or 6 it never returns.) Is this expected (i.e. I'm doing something that isn't really expected to be done in volt)? Is there a different approach I should be pursuing? (I am more experienced with MySQL, Oracle, etc...)