getProductTreeData uses too much memory

[lnicola]

Right now, sp_get_dashboard_products returns the site footprint for each product in the result, even if it's the same for all products in a site.

This has caused memory usage issues in the past and requires us to edit php.ini to increase the memory limit. According to one user's report, setting it to 1 GB was not enough, so it's really bad and should be fixed.

The solution is to retrieve the site definitions separately and do the lookup on the client.

For anyone affected, a workaround is to update the site to a simpler footprint.