[mapguide-trac] #791: Join performance problem

[MapGuide Open Source]

#791: Join performance problem
-------------------------------+--------------------------------------------
   Reporter:  amorsell         |       Owner:       
       Type:  defect           |      Status:  new  
   Priority:  high             |   Milestone:       
  Component:  Feature Service  |     Version:  2.0.2
   Severity:  critical         |    Keywords:       
External_id:                   |  
-------------------------------+--------------------------------------------
 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.

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/791>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals