Tom: There were definitely changes in this area. Can you share the WFS filter plus the resulting SQL in each version. This is the type of thing that should have gotten better in 7.0 as WFS filters are translated more completely into native SQL. It’s possible I introduced an inefficiency in that translation beyond what was done for PostGIS in mapogcfilter.c in 6.4. -Steve
-----Original Message----- From: mapserver-users [mailto:[email protected]] On Behalf Of Kralidis, Tom (EC) Sent: Thursday, November 17, 2016 8:14 PM To: [email protected] Subject: [mapserver-users] PostGIS date queries performance issues Hi all: using 7.0.2 against a PostgreSQL 9.3/PostGIS 2.2 instance we're getting very long (timeouts even) response times when doing WFS filters against PostgreSQL date types. I've posted a Gist at [1] to help in reporting. Note that this functionality used to work with acceptable performance in 6.4.x. Looking deeper (see Gist) it appears that the SQL queries that MapServer crafts for PostgreSQL are different. When I try the 7.0.2 based SQL in a psql prompt, the same very long response time results. Any idea what could be going on here? Thanks ..Tom [1] https://gist.github.com/tomkralidis/006594382d6339c2047b441108a3991b _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
