[mapguide-trac] #771: Performance: Select * being used to render a layer when it should only select required properties

[MapGuide Open Source]

#771: Performance: Select * being used to render a layer when it should only
select required properties
-------------------------------+--------------------------------------------
   Reporter:  ronnielouie      |       Owner:  ronnielouie
       Type:  defect           |      Status:  new        
   Priority:  high             |   Milestone:             
  Component:  Mapping Service  |     Version:  2.0.1      
   Severity:  major            |    Keywords:             
External_id:  1099522          |  
-------------------------------+--------------------------------------------
 The queries select all properties from the tables. The queries should be
 smart enough to only request the properties outlined in the layer
 definition. At a minimum request only the geometry and the Feature Id if
 no properties are selected in the layer. Many tables could be large and
 contain many large text fields so effectively selecting * from the table
 can generate large disk I/O and needlessly consume network bandwidth.

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