[GeoNode-users] view_layer slowing down

Fri Aug 7 04:12:19 PDT 2015

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> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20150807/7036b030/attachment-0001.html>