[GeoNode-users] view_layer slowing down

[FERRARI Hugo]

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 a écrit :
>> Send geonode-users mailing list submissions to
>> 	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
>>
>> You can reach the person managing the list at
>> 	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>
>> To:geonode-users at lists.osgeo.org
>> Subject: [GeoNode-users] Internal Server Error
>> Message-ID:
>> 	<CA+SjRdEzZ0i=ridubKvTh9DBKUxCpodfuNxb0hdA0sjBdNt3FA 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>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Wed, 29 Jul 2015 21:40:27 +0200
>> From: Simone Dalmasso<simone.dalmasso at gmail.com>
>> To: Leonardo Jauregui<leojauregui.geog at gmail.com>
>> Cc:"geonode-users at lists.osgeo.org"  <geonode-users at lists.osgeo.org>
>> Subject: Re: [GeoNode-users] Internal Server Error
>> Message-ID:
>> 	<CAAHAC+f2fUE0nMndb2R59GkgudiRjz+Hm6meYwoVqozYq2yH3A 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>
>> 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
>>>
>>>
>>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20150807/9d68e392/attachment.html>