View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0005823||mantisbt||performance||public||2005-06-20 16:50||2007-07-22 17:22|
|Summary||0005823: user_get_accessible_(sub)projects has too much overhead|
user_get_accessible_projects and user_get_accessible_subprojects are used for two things:
For 1, the hierarchy is not needed at all. A new function get_accessible_projects could return both the projects and the subprojects to which the user has access. For 2, the name of the project is needed and it is already selected in u_ga(sub)projects.
This would save a query for each project (namely that for retreiving the name of the project) and it would save time when merely retreiving the projects a user has access to. I suggest using the function helper_project_specific_where to return a list or array with projects a user has access to. I suggest using user_get_accessible_projects to return an array or object which contains the structure of projects and subprojects, including their names.
I made a overview of the functions which have to be adapted for this. If you agree and I have enough time, I will do it.
|Tags||No tags attached.|