Steve: info can be found at https://gist.github.com/tomkralidis/006594382d6339c2047b441108a3991b
> -----Original Message----- > From: Lime, Steve D (MNIT) [mailto:[email protected]] > Sent: 18 November 2016 13:10 > To: Kralidis, Tom (EC); [email protected] > Subject: RE: PostGIS date queries performance issues > > 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
