Parsing a CQL filter of that size is bound to take a while and then it has
to be translated into an SQL statement which will also take a while.
I suspect there must be an easier way of doing what ever you are doing with
out the need for a 20Kb filter.
Ian
On 1 March 2018 at 13:14, Bernhard Kiselka <
bernhard.kise...@prisma-solutions.at> wrote:
> Hi list!
>
> I did not do so much research as in https://gis.stackexchange.com/a/82305
> but as my data increased, my CQL_FILTER containing IDs that shall be
> rendered increased from 600 to 1800 (20 kilobyte of filter string!) and
> GeoServer response time increased from 1 second to 5 seconds.
>
> Does someone has any guesses why GeoServer is slowing down exponentially?
>
> I assume that parsing the filter is slow, because the postgres database
> query is _not_ slowing down that much (the query itself takes less than
> 100ms).
>
> Thanks for any thoughts!
>
> Best regards,
> Bernhard
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Geoserver-users mailing list
>
> Please make sure you read the following two resources before posting to
> this list:
> - Earning your support instead of buying it, but Ian Turton:
> http://www.ianturton.com/talks/foss4g.html#/
> - The GeoServer user list posting guidelines: http://geoserver.org/comm/
> userlist-guidelines.html
>
> If you want to request a feature or an improvement, also see this:
> https://github.com/geoserver/geoserver/wiki/Successfully-
> requesting-and-integrating-new-features-and-improvements-in-GeoServer
>
>
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
--
Ian Turton
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
