Ticket #3382 (closed enhancement: duplicate)

Opened 3 years ago

Last modified 3 years ago

WMS Time: postgis layers should not use date_trunc function

Reported by: assefa Owned by: assefa
Priority: normal Milestone: 6.0 release
Component: WMS Server Version: unspecified
Severity: normal Keywords: wms time postgis
Cc:

Description

It seems that using date_trunc function could be slower that using simple comparison.

There was a thread on this in mapserver list:

 http://n2.nabble.com/WMS-TIME-parameter-slow-td4709981.html

Change History

Changed 3 years ago by assefa

the docs related to WMS time is: http://mapserver.org/ogc/wms_time.html

The reason date_trunc is used to accomodate requests where queries like time=2001-01-01 expects to return all values. I believe this assumption should still be respected for WMS.

Maybe It should be possible to not always use date_trunc and be able to use regular comparisons.

Changed 3 years ago by pramsey

  • status changed from new to closed
  • resolution set to duplicate

Please see #3374

Note: See TracTickets for help on using tickets.