Opened 15 years ago
Closed 15 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 , 15 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
comment:2 by , 15 years ago
| Resolution: | fixed |
|---|---|
| Status: | closed → reopened |
Reverted previous changeset and reopened the ticket because the fix was incomplete.
comment:3 by , 15 years ago
| Resolution: | → duplicate |
|---|---|
| Status: | reopened → closed |
Use ticket #272 instead.
Note:
See TracTickets
for help on using tickets.
http://trac.osgeo.org/mapguide/changeset/3469