Ticket #1234 (closed defect: fixed)
MapServer/PostGIS query mechanism should use primary key on a table
| Reported by: | margottid@… | Owned by: | refractions |
|---|---|---|---|
| Priority: | high | Milestone: | |
| Component: | PostGIS Interface | Version: | 4.2 |
| Severity: | normal | Keywords: | |
| Cc: |
Description
After installing PostGIS and importing data from Shapefile, I noticed that CGI query/nquery were from 10 to 15 times slower than if I were using shapefiles. I tried to add many and many indexes on my fields, but solution came from Paul Ramsey: adding an oid index. He also suggested to issue this bug, saying that "the mapserver/postgis query mechanism should be upgraded to automatically use the primary key on a table if such a key exists." Daniele
Change History
Note: See
TracTickets for help on using
tickets.
