Forum .LRN Q&A: Site-map performance !

Posted by Denis Barut on 12/04/03 03:05 PM

Hi,

we just add more than 600 classes for one of our project, and now the site-map is simply unusable (take more than five/ten minutes to appear). Somebody know if there something to do (without changing the server !)

Thank you for the feedback

Denis

2: Re: Site-map performance ! (response to 1)

Posted by Jeff Davis on 12/04/03 03:11 PM

oracle or postgresql? what version of the code? did you
vacuumdb or analyze?

3: Re: Site-map performance ! (response to 1)

Posted by Caroline Meeks on 12/04/03 03:59 PM

Hi Denis,

I have a PG dotRLN 4.6.3 site with 1500 class instances and the query "site-nodes" in acs-subsite/www/admin/index-postgresql.xql seems to be the problem.

Jeff and I have been looking at the query and talking on IRC. With 1500 classes I have 15181 nodes. The query does a permission check on every node so at 2ms per permission check that is 30 seconds.

We are working on a solution. Stop by IRC if you want.

4: Re: Site-map performance ! (response to 1)

Posted by Denis Barut on 12/04/03 06:43 PM

Hi Jeff and Caroline,

Thanks for the answer.

Jeff we use PG.

Caroline I have remove the two line that check the permissions to see if it's make a different, but it's not a big change. But I need some more tests.

I would be please to stop at IRC, just tell me how to proceed.

Denis

5: Re: Site-map performance ! (response to 1)

Posted by Denis Barut on 12/04/03 06:54 PM

jeff,

yes we've done vacuumdb --analyze

denis

6: Re: Site-map performance ! (response to 1)

Posted by Caroline Meeks on 12/04/03 07:12 PM

Denis,

try also removing the permission check in services_select.

Note that this works if you only allow site wide admin to use the sitemap. This tends to be the case in dotLRN. We are working on a general solution.

I've put this problem into bug 1252.

7: Re: Site-map performance ! (response to 1)

Posted by Denis Barut on 12/04/03 10:17 PM

Thanks Caroline,

after removing permissions of services_select and also path_select, and its much faster !!

we will check for site-wide admin in this page