LoadMap performace issues

[assefa]

It was reported that performance was very poor when using Fusion Mapguide with Oracle DB. This bug is to track any enhancements that need to be done to address this.

[assefa]

first commit done in r1541: cleanup of LoadMap.php

• remove things that were not used,
• optimization for layer types
• easier way to build the json output
• min/max scales are now part of the layer information so we can eventually remove the scale ranges info.

[assefa]

scale ranges have been remove from the load map and put into other client/server side function r1543 r1544. Only the legend uses the scale ranges for now.

[assefa]

The first set of optimization had a significant impact on the time of the load map with oracle data (which was the initial goal). Here are some numbers, part of an e-mail:

" I did more tests with the current svn version of fusion. The map file contains about 15 oracle layers (most of them are tables that are exactly the same: with about 1000 records and 15 attributes):

• The LoadMap time before the change was about 39seconds
• the LaodMap time after the changes is about 4 seconds

I could not really replicate the level of slowness described by Tom "They had a map with 162 layers taking more than 30 minutes to load in the Fusion viewer. Even a map with 10 layers took 7 minutes.",

but I assume the more you add layers the more time the load map would take (for example adding an additional 10 layers in the my test map bumped the loadmap time from 39s to 73s) "

I will leave this bug open for some time until we get a better oracle test data or if there are other issues.

[madair]

implemented; open a new ticket to report any issues