MapGuide Open Source:  Home |  Download |  Internals

Ticket #272 (new defect)

Opened 10 months ago

Last modified 1 month ago

Improve speed of rendering engine by not using "select * from table"

Reported by: ksgeograf Assigned to: stevedang
Priority: medium Milestone:
Component: Mapping Service Version: 2.0.1
Severity: minor Keywords: render select style
Cc: External ID:

Description

The current render engine will load the entire row from the datasource. This involves a potentially large overhead, as it typically needs only a few columns to style the layer.

In a test case I worked on, I was able to reduce render time from 20 to 12 seconds, just by removing unused columns from the dataset.

This solution does not work when the data is required for anything but rendering.

For a simple fix, I propose that the render figures out what columns are used by looking at the scalerange condition rules and tooltip.

It might introduce a significant overhead to preparse this data. If this overhead is inacceptable, the RuntimeMap? could include this information, so that it is done once pr. map, and not at each rendering.

Change History

10/04/07 14:25:28 changed by tomfukushima

  • owner set to stevedang.

Thanks Kenneth, the speedup that you are seeing is pretty substantial.

10/13/07 00:14:41 changed by zspitzer

I have seen this speedup effect as well. Anyone using AutoCAD Map with ther database has their performance crippled by this as Map adds all 20 odd ADMP* columns to tables.

02/28/08 23:06:33 changed by tomfukushima

  • milestone deleted.

06/26/08 09:24:22 changed by zspitzer

  • version changed from 1.2.0 to 2.0.1.