[fusion-trac] #129: LoadMap performace issues

[Fusion]

#129: LoadMap performace issues
-------------------------+--------------------------------------------------
 Reporter:  assefa       |         Owner:  assefa  
     Type:  enhancement  |        Status:  assigned
 Priority:  P2           |     Milestone:  2.0     
Component:  Widgets      |       Version:  1.0.7   
 Severity:  Major        |    Resolution:          
 Keywords:               |   External_id:          
    State:  New          |       Browser:  All     
       Os:  All          |  
-------------------------+--------------------------------------------------
Changes (by assefa):

 * cc: pagameba (added)

Comment:

 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.

-- 
Ticket URL: <http://trac.osgeo.org/fusion/ticket/129#comment:3>
Fusion <http://trac.osgeo.org/fusion>
Fusion is a web-mapping application development framework for MapServer and MapGuide OS.