[GeoNode-users] Query on a medium sized postgis table layer takes forever on 2.4b25

[Francesco Bartoli]

In addition to what Paolo suggests you can check if the layer has been published and reacts properly from the layer preview inside geoserver by issuing CQL filters. For examples please take a look here

Hope this helps
Rgs,
Francesco

Il giorno 17/giu/2015, alle ore 15:36, Paolo Corti <pcorti at gmail.com> ha scritto:

> On Wed, Jun 17, 2015 at 2:30 PM, Rainer Lissewski
> <rainerlissewski at gmail.com> wrote:
>> Hi, in the map view, I have tried to query a single attribute value
>> (varchar) from a layer with about 5000 rows, and it has been running over an
>> hour now, with no result. If someone can guide me where to look for the
>> possible culprit (geoserver, django,...), I would gladly take any hints
>> 
> 
> Things I would check (in this order):
> * response to the getfeatureinfo request using your browser debug toolbar
> * geoserver log
> * try the query in postgis and check it using EXPLAIN
> 
> regards
> p
> 
> 
> 
> -- 
> Paolo Corti
> Geospatial software developer
> web: http://www.paolocorti.net
> twitter: @capooti
> skype: capooti
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20150617/18ef4a14/attachment.html>