Hello,
We have just start using eGroupware for our project management.
After injecting many projects with many sub-projects, eGroupware
was insanely slow on the project manager homepage (~ 120 sec)
~20000 egw_links rows.
After some lookup on the blocking request and the database structure,
i wrote a fairly simple patch attached to this mail (6 lines).
It removes the use of the fullset left join on egw_links/egw_pm_projects
by adding, for root projects, a default link entry with:
link_id1=-1 * link_id2
It allows to simply request root project with not null link_id1 (<0).
The patch is far fully functional. I’ve made a shortcut to cancel
automatic link deletion managed in what seems to be an automatic
link garbage collector. I don’t have time to go further in eGroupware
internals and this patch do the job for us making eGroupware usable with
many active root projects.
Perhaps this study could be useful to eGroupware developers.
Best regards,
Guillaume FOUGNIES
Eulerian Technologies
