Opened 12 years ago
Closed 12 years ago
#2085 closed defect (invalid)
Review performance of TopoGeometry layer constraints
| Reported by: | strk | Owned by: | strk |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.0.2 |
| Component: | topology | Version: | 2.0.x |
| Keywords: | Cc: |
Description
I just realized how slow it is to add TopoGeometry objects in a TopoGeometry layer compared with updating any other field.
I'm talking about 2/3 minutes versus subsecond time to set a text field for a table with less than 4000 rows.
So I guess the layer CHECK constraints are slowing things down.
This ticket is to review that and see if it can be improved.
If it cannot, at least document what a good workaround is before running the UPDATE ... SET topogeom = toTopoGeom mantra
Note:
See TracTickets
for help on using tickets.
Alright, forget it, it was me writing a stupid query.It takes a fraction of second even with topogeometry objects…