[GeoNode-users] view_layer slowing down

Fri Aug 7 07:35:14 PDT 2015

Hey Hugo,

How many users do you have? And how many datasets (well, I guess layers 
in this case, not docs)?

I have only very few contributing users (4-5 at the moment), but the 
list of people with login grows now (currently 45). Click on the 
"Layers" list view is resolved in about 4 secs.
So I wonder from what size on one needs to to worry.
(though, I am on 2.0)

ciao,
stefan

Am 07.08.15 um 07:12 schrieb Simone Dalmasso:
> Hi Hugo thanks for the detailed report. We are trying to improve the
> performances when there are a lot of users, although for this case (
> detail template) there might be a way to avoid such a big query.
>
> I think we still have one open ticket, could you check and
> integrate/create it in case? I'll take a look asap.
>
> Ciao.
>
> Il venerdì 7 agosto 2015, FERRARI Hugo <ferrari_hugo at yahoo.fr
> <mailto:ferrari_hugo at yahoo.fr>> ha scritto:
>
>     Hello everybody
>     as my geonode database gets bigger, displaying layer details
>     template goes very slow.
>     It takes more than 10 seonds to display layer template.
>
>     found in postgres log, here's a big request that takes almost 5
>     seconds to execute
>
>       SELECT  distinct "people_profile"."id",
>     "people_profile"."password", "people_profile"."last_login",
>     "people_profile"."is_superuser", "people_profile"."username",
>     "people_profile"."first_name", "people_profile"."last_name",
>     "people_profile"."email", "people_profile"."is_staff",
>     "people_profile"."is_active", "people_profile"."date_joined",
>     "people_profile"."organization", "people_profile"."profile",
>     "people_profile"."position", "people_profile"."voice",
>     "people_profile"."fax", "people_profile"."delivery",
>     "people_profile"."city", "people_profile"."area",
>     "people_profile"."zipcode", "people_profile"."country"
>       FROM "people_profile"
>       LEFT OUTER JOIN "guardian_userobjectpermission" ON (
>     "people_profile"."id" = "guardian_userobjectpermission"."user_id" )
>       LEFT OUTER JOIN "people_profile_groups" ON ( "people_profile"."id"
>     = "people_profile_groups"."profile_id" )
>       LEFT OUTER JOIN "auth_group" ON (
>     "people_profile_groups"."group_id" = "auth_group"."id" )
>       LEFT OUTER JOIN "guardian_groupobjectpermission" ON (
>     "auth_group"."id" = "guardian_groupobjectpermission"."group_id" )
>       WHERE (("guardian_userobjectpermission"."object_pk" = '1015'  AND
>     "guardian_userobjectpermission"."content_type_id" = 38 ) OR
>     ("guardian_groupobjectpermission"."object_pk" = '1015'  AND
>     "guardian_groupobjectpermission"."content_type_id" = 38 ) )
>
>     Is it the usual request ?
>
>     Thank you for your advices
>     Hugo
>
>>     Hello Geonode community.
>>
>>     Usually if you want to retrieve OWS data from a geoserver instance
>>     you can simply add your credentials before the dn name in the http
>>     request (even if it is not a secure way), for exemple
>>     |http://user:password@dn_site:8080/geoserver/<link to the service ex:wms?request=GetCapabilities>|
>>     But it does not work with geonode
>>     I guess it is because authentication has been delegated to geonode
>>     proxy, doesn't it ?
>>     how can I get through this, do I have to open a session  first and
>>     then querying geoserver ?
>>
>>     I can't find it in the documentation.
>>     Thank you for your advices.
>>     Hugo FERRARI
>>
>>
>>
>>     Le 30/07/2015 17:18, geonode-users-request at lists.osgeo.org
>>     <javascript:_e(%7B%7D,'cvml','geonode-users-request at lists.osgeo.org');>
>>     a écrit :
>>>     Send geonode-users mailing list submissions to
>>>     	geonode-users at lists.osgeo.org  <javascript:_e(%7B%7D,'cvml','geonode-users at lists.osgeo.org');>
>>>
>>>     To subscribe or unsubscribe via the World Wide Web, visit
>>>     	http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users
>>>     or, via email, send a message with subject or body 'help' to
>>>     	geonode-users-request at lists.osgeo.org  <javascript:_e(%7B%7D,'cvml','geonode-users-request at lists.osgeo.org');>
>>>
>>>     You can reach the person managing the list at
>>>     	geonode-users-owner at lists.osgeo.org  <javascript:_e(%7B%7D,'cvml','geonode-users-owner at lists.osgeo.org');>
>>>
>>>     When replying, please edit your Subject line so it is more specific
>>>     than "Re: Contents of geonode-users digest..."
>>>
>>>
>>>     Today's Topics:
>>>
>>>         1. Internal Server Error (Leonardo Jauregui)
>>>         2. Re: Internal Server Error (Simone Dalmasso)
>>>         3. need help resetting psql geonode password (Charles Coss?)
>>>         4. Re: need help resetting psql geonode password (Paolo Corti)
>>>         5. Re: Internal Server Error (Leonardo Jauregui)
>>>         6. Re: Internal Server Error (Ariel Nunez)
>>>
>>>
>>>     ----------------------------------------------------------------------
>>>
>>>     Message: 1
>>>     Date: Wed, 29 Jul 2015 15:26:47 -0400
>>>     From: Leonardo Jauregui<leojauregui.geog at gmail.com>  <javascript:_e(%7B%7D,'cvml','leojauregui.geog at gmail.com');>
>>>     To:geonode-users at lists.osgeo.org  <javascript:_e(%7B%7D,'cvml','geonode-users at lists.osgeo.org');>
>>>     Subject: [GeoNode-users] Internal Server Error
>>>     Message-ID:
>>>     	<CA+SjRdEzZ0i=ridubKvTh9DBKUxCpodfuNxb0hdA0sjBdNt3FA at mail.gmail.com>  <javascript:_e(%7B%7D,'cvml','CA%2BSjRdEzZ0i%5Cx3dridubKvTh9DBKUxCpodfuNxb0hdA0sjBdNt3FA at mail.gmail.com');>
>>>     Content-Type: text/plain; charset="utf-8"
>>>
>>>     500
>>>     Internal Server Error
>>>
>>>     that is the mesage after I installed geonode 2.4 un Ubuntu 14.04,
>>>
>>>       What is mising ?
>>>
>>>
>>>     Leonardo from Bolivia
>>>     -------------- next part --------------
>>>     An HTML attachment was scrubbed...
>>>     URL:<http://lists.osgeo.org/pipermail/geonode-users/attachments/20150729/8e1f78da/attachment-0001.html>  <http://lists.osgeo.org/pipermail/geonode-users/attachments/20150729/8e1f78da/attachment-0001.html>
>>>
>>>     ------------------------------
>>>
>>>     Message: 2
>>>     Date: Wed, 29 Jul 2015 21:40:27 +0200
>>>     From: Simone Dalmasso<simone.dalmasso at gmail.com>  <javascript:_e(%7B%7D,'cvml','simone.dalmasso at gmail.com');>
>>>     To: Leonardo Jauregui<leojauregui.geog at gmail.com>  <javascript:_e(%7B%7D,'cvml','leojauregui.geog at gmail.com');>
>>>     Cc:"geonode-users at lists.osgeo.org"  <javascript:_e(%7B%7D,'cvml','geonode-users at lists.osgeo.org');>  <geonode-users at lists.osgeo.org>  <javascript:_e(%7B%7D,'cvml','geonode-users at lists.osgeo.org');>
>>>     Subject: Re: [GeoNode-users] Internal Server Error
>>>     Message-ID:
>>>     	<CAAHAC+f2fUE0nMndb2R59GkgudiRjz+Hm6meYwoVqozYq2yH3A at mail.gmail.com>  <javascript:_e(%7B%7D,'cvml','CAAHAC%2Bf2fUE0nMndb2R59GkgudiRjz%2BHm6meYwoVqozYq2yH3A at mail.gmail.com');>
>>>     Content-Type: text/plain; charset="utf-8"
>>>
>>>     Hi did you run the Geonode createduperuser and the geonode-updateip
>>>     commands.
>>>     If you take a look at the Apache error log you might get more info.
>>>
>>>     Il mercoled? 29 luglio 2015, Leonardo Jauregui<leojauregui.geog at gmail.com>  <javascript:_e(%7B%7D,'cvml','leojauregui.geog at gmail.com');>
>>>     ha scritto:
>>>
>>>>     500
>>>>     Internal Server Error
>>>>
>>>>     that is the mesage after I installed geonode 2.4 un Ubuntu 14.04,
>>>>
>>>>       What is mising ?
>>>>
>>>>
>>>>     Leonardo from Bolivia
>>>>
>>>>
>>>>
>>
>
>
>
> --
> Simone
>
>
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users
>