Forum .LRN Q&A: Re: Cluster and performance

Posted by Jose Agustin Lopez Bueno on

Thanks for the quick answer!

I have replaced the code of the proc with the
old version (see below) and the performace increase
greatly. Some pages with time load de 20 seconds
-> 2-3 seconds.

I expect you change the code in the official release.

Thanks very much!

ad_proc -public site_node::get_url_from_object_id {
} {
    returns a list of urls for site_nodes that have the given object
    mounted or the empty list if there are none. The
    url:s will be returned in descending order meaning any children will
    come before their parents. This ordering is useful when deleting site nodes
    as we must delete child site nodes before their parents.
} {
  return [db_list select_url_from_object_id {}]