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

Change History (1)

comment:1 by strk, 12 years ago

Resolution: invalid
Status: newclosed

Alright, forget it, it was me writing a stupid query.It takes a fraction of second even with topogeometry objects…

Note: See TracTickets for help on using tickets.