capeterson/Visualforce-Field-History — Issue #5: Excessive SOQL use
Author: capeterson
Created: 2011-10-14 01:13:25+00:00
State: open

The way SOQL queries are run - by iterating over the child objects and running a query for each - is very inefficient against governor limits, in particular the total number of SOQL queries.

The child object query functionality should be changed to run multiple subqueries for child objects rather than totally separate SOQL queries. This should cut the amount of resources and DB load down dramatically on complex objects with a large number of relationships.