A user’s home page (or at least mine) loads slowly. Must be some memory stuff that can be optimized to a query.

Submitted by Sander Vermolen on 20 September 2010 at 17:32

Problem is caused by the number of queries executed by the page. Executing a single query has a significant overhead in WebDSL (and/or Hibernate). When executing multiple queries the overhead adds up to noticeable amounts. One solution would be to combine multiple queries into one, yet this would yield a complex result set not yet supported by WebDSL. Another solution involves browsing the object structure, however, this is undesirable due to the vast number of queries required (it does not scale). Awaiting a resolution in WebDSL: Blocked for now. Issue 142 (https://yellowgrass.org/issue/YellowGrass/142) is related.

If this issue is blocked then you should submit an issue to the WebDSL project. And it seems the issue shouldn’t be closed either, since it is not resolved.

I already discussed the issue IRL, therefore I did not create a new issue. But, indeed, a WebDSL issue may be useful for documentation purposes. I will create one right away.

As for the issue being closed: I use the strategy of closing blocked issues, that way they do not get in my way. I can always pop up a list of blocked issues and check whether one of them can be reopened. I guess this is pragmatic and non-standard usage, but works fine. Maybe YellowGrass could offer more advanced support for issues statuses…

I also fixed this problem temporarily by removing project tag displays from a user’s home page. When unblocked, tag displays can be reconfigured.