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
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
https://lists.sourceforge.net/lists/listinfo/geoserver-users
