Forum .LRN Q&A: Re: Degraded performance adding users to dot

Collapse
2: Re: Degraded performance adding users to dot (response to 1)
Posted by Dirk Gomez on 01/14/04 12:32 PM
Is only the database involved or do you touch external systems?

Can you be sure that PostgreSQL queries are the culprit? If yes, find out which queries have gotten slow. Developer-Support may be of immense help.

Then run explain plan on the slow query and post the results. It's quite likely that someone will be able to diagnose the problem then.

Collapse
3: Re: Degraded performance adding users to dot (response to 2)
Posted by Tilmann Singer on 01/14/04 01:14 PM
The problem is that dotlrn::user_add triggers a huge number of other operations - depending on the number of other dotlrn packages installed, which are difficult to unwind. This is even more true when adding users to communities I believe, because then lots of personal data will be created for them for each dotlrn package installed.

Anyway, Dirks advice to install acs-developer-support is an excellent one. You might find one or two queries that account for the main part of the time the operation takes and find a way to optimize or postpone them.