Opened 16 years ago

Closed 13 years ago

#791 closed defect (fixed)

Join performance problem

Reported by: amorsell Owned by:
Priority: high Milestone:
Component: Feature Service Version: 2.0.2
Severity: critical Keywords:
Cc: brucedechant External ID:

Description

Many MGOS users are experiencing performance problems with feature joins. The attached MGOS package demonstrates this problem. Once you load this package, look at the AU folder in your library. There are two data connections to an Access database: AU_Database and AU_Database_Uploaded. The latter uses a file uploaded to the MapGuide Library so is easier to use here for replication purposes. The former uses a Windows DSN. The performance problem exists for either. Examine the parcels feature source for details on the join and the parcels2 layer for the layer definition. To see the performance problem, preview the AU Map2 map in Studio below a zoom scale of 35,000.

Change History (4)

comment:1 by amorsell, 16 years ago

Attachment is too large for Trac. It can be downloaded here: http://www.spatialgis.com/AU_join_problem.mgp

comment:2 by brucedechant, 16 years ago

Cc: brucedechant added

comment:3 by jbirch, 15 years ago

Any progress on this with 2.1? If not, please update version, otherwise, please close the ticket. Will close this ticket if no response by next ticket cleanup cycle.

comment:4 by jng, 13 years ago

Resolution: fixed
Status: newclosed

Marking as fixed as a result of r6333 and r6348.

Note: See TracTickets for help on using tickets.