Hi Ian,
the problem is that I have a view, where i can't have an index. I could
try using a materialized view, but I think the main performance problem
lies elsewhere, and I'm not sure if I'm using the right approach here.
Sincerely,
Eva
Am 27.06.2016 um 16:37 schrieb Ian Turton:
Eva,
I assume you have an index on SpeciesID?
Ian
On 27 June 2016 at 15:31, emgerstner
<eva-maria.gerst...@senckenberg.de
<mailto:eva-maria.gerst...@senckenberg.de>> wrote:
Hi Jukka,
i'm running PostgreSQL (with PostGIS) 9.2.14. From the Geoserver
log file, I see that the call is converted into something like
Request: getFeature
service = WFS
version = 1.0.0
baseUrl = http://localhost:8080/geoserver/
query[0]:
filter = [[ SpeciesID = 16 ] OR [ SpeciesID = 17 ] OR [
SpeciesID = 18 ] OR [ SpeciesID = 40 ] OR [ SpeciesID = 41 ] OR ...
In the PostgreSQL log, I see the following query
SELECT "SpeciesID","Name",encode(ST_AsEWKB("geom"),'base64') as
"geom" FROM "public"."view_map" WHERE (("SpeciesID" = 16 AND
"SpeciesID" IS NOT NULL ) OR ("SpeciesID" = 17 AND "SpeciesID" IS
NOT NULL ) OR ("SpeciesID" = 18 AND "SpeciesID" IS NOT NULL ) OR ...
The query itself is quite slow (about 10 sec for 8000 ids), but
the main performance loss appears to be with Geoserver. I'm not
sure, but this seems to me an inefficient way to handle the
CQL_FILTER request.
Sincerely,
Eva
Am 27.06.2016 um 15:31 schrieb Rahkonen Jukka (MML):
Hi,
Probably Geoserver itself in not slow but if gets results from
the data source slow. Where do you keep your data?
-Jukka Rahkonen-
------------------------------------------------------------------------
Lähettäjä: emgerstner <mailto:eva-maria.gerst...@senckenberg.de>
Lähetetty: 27.6.2016 16:05
Vastaanottaja: geoserver-users@lists.sourceforge.net
<mailto:geoserver-users@lists.sourceforge.net>
Aihe: [Geoserver-users] CQL_FILTER with IN
Hello,
I'm developing an web application based on OpenLayers 3 and
Geoserver
2.9.0. In this application, the user can search in a database
containing
about 8000 entries of species with their locations. The search
result is
then displayed in a map with the locations of the found species.
To this end, I first do a database query based on the search
parameters
(using PHP), which returns a list of species ids. I then forward
this
list to Geoserver with a WFS request using CQL_FILTER such as
CQL_FILTER=SpeciesID IN (16,17,18,40,41,...)
Geoserver then returns a map with only these species in the search
result, which is fine. However, I run into performance problems
when the
list of ids becomes too large. For 8000 ids, it takes Geoserver
about 2
minutes to draw the map which is way too long. The database query
may
return anything between 0 and 8000 results.
Is there another way to solve this problem more efficiently or
some way
I can optimize Geoserver for this? I would be glad for any help.
Sincerely,
Eva
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park
in San
Francisco, CA to explore cutting-edge tech and listen to tech
luminaries
present their vision of the future. This family event has
something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park
in San
Francisco, CA to explore cutting-edge tech and listen to tech
luminaries
present their vision of the future. This family event has
something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Ian Turton
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users