[mapguide-users] Fusion + Oracle datasource problem

[Paul Spencer]

Hi Klaus,

this is something that others have reported to me as well, it seems  
that Fusion does some dumb things on initialization that it doesn't  
really need to do, including retrieving the schema of layers in the  
MapDefinition.  Fixing this will require some rearchitecting of how  
Fusion starts up and what info is actually needed to be returned to  
the client.  There are actually two blocking points, one is getting  
too much info from the database (which appears to be very slow) and  
the other happens when a MapDefinition contains a lot of layers and/or  
thematic layers with lots of classes, Fusion generates a large  
response that has to be evaluated in the client and this causes a long  
delay too.

Both are probably unnecessary or can be minimized, but it will take  
some time.  I hope that this will be part of the next Fusion release.

Cheers

Paul

On 17-Jun-08, at 7:15 AM, Klaus Lehtonen wrote:

>
> Hi
>
> The problem is that the Fusion Viewer loads very slowly compared to  
> AJAX and
> DWF viewers when using Oracle database as a feature source. The AJAX  
> and DWF
> viewers load to browser in about two seconds, but the Fusion Viewer  
> takes
> tens of seconds and with some maps times out after a minute. The  
> load time
> seems to be related to the amount of  layers that use database as  
> source. If
> we use only sdf data sources the Fusion Viewer loads very quickly.  
> After the
> Fusion viewer has loaded zooming and panning work quickly, so the  
> problem is
> only in the initial loading.
>
> I used Firebug to investigate the issue and it shows the LoadMap.php  
> takes a
> lot of time. Other files load pretty quickly. The MapGuide logs show  
> ten
> second pauses when GetClassDefinition has been called, but this only  
> happens
> with part of the calls. Some of the calls cause no problems. During  
> loading
> mgserver2009.exe is the only application using  CPU time and it does  
> not
> seem to matter if we use Oracle tables directly or through views.
>
> I wonder if anyone else has had problems using Oracle and Fusion  
> viewer?
>
> Klaus Lehtonen
> -- 
> View this message in context: http://www.nabble.com/Fusion-%2B-Oracle-datasource-problem-tp17884373p17884373.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users