Opened 16 years ago

Closed 16 years ago

#771 closed defect (duplicate)

Performance: Select * being used to render a layer when it should only select required properties

Reported by: ronnielouie Owned by: ronnielouie
Priority: high Milestone:
Component: Mapping Service Version: 2.0.1
Severity: major Keywords:
Cc: External ID: 1099522

Description

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.

Change History (3)

comment:1 by ronnielouie, 16 years ago

Resolution: fixed
Status: newclosed

comment:2 by ronnielouie, 16 years ago

Resolution: fixed
Status: closedreopened

Reverted previous changeset and reopened the ticket because the fix was incomplete.

http://trac.osgeo.org/mapguide/changeset/3499

comment:3 by tomfukushima, 16 years ago

Resolution: duplicate
Status: reopenedclosed

Use ticket #272 instead.

Note: See TracTickets for help on using tickets.