[mapguide-users] RE: MGE performance. It's soooooo Slllllllooooooowwww

[Gary Morin]

Hi

We have put in loads of work porting an 6.5 site to MGE, to be honest we
had to abort our first attempt, it was just too slow and not stable
enough, but after a lot of hard work by our team it's about to go live and
I can say it now out performs the old 6.5 by a long way.

We are using MGE 2011 on 64bit platform, we have spatial data store in SDF
and PostGIS, SDF for the static data and PostGIS for the dynamic data. We
have around 50Gb of vector data on a 100+ layers, so there is a reasonable
amount of data on the system

We use a heavily customised Basic Ajax viewer and have found using the GIF
format the best compromise for quality and speed. You need your sdf on the
local MGE server, but our DB is on another server on a 1Ghz Network.

I notice you say you are using themed layers via Joins, I presume you mean
MapGuide Joins?, don't, they are really slow. Instead create a view in
your DB and theme on that, again set your scale range so you are not
trying to display all 23k parcels at once. is not a very big number, so it
should not be a problem.
We have SQL2005, but all data that directly relates to MapGuide has ported
to PostGIS, I have heard other people say that SQL 2008 Spatial is now
quite good, but we are getting great results from PostGIS and my
development team swear by it.

We have also done some serious load testing on the servers and have
simulated 20 concurrent users hitting the servers nonstop for 72 hours and
with good results.

So keep at, it will start clicking into place.

Regards

Gary

Keynetix Ltd
Member of the Key Systems Group

Tel. +44 (0) 1527 68888
Fax: +44 (0) 1527 62880
Dir. +44 (0) 1604 891152
Mobile: 07801 371438
Web Site: http://www.keynetix.com

KeySpatial - Team GIS, 
Unite your Business Information
www.keynetix.com/KeySpatial

IMPORTANT: Please address all support & sales correspondence to either
support at keynetix.com or sales at keynetix.com Addressing support questions to
individuals may delay the response


> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-
> bounces at lists.osgeo.org] On Behalf Of frosty1_4me
> Sent: 28 January 2011 22:03
> To: mapguide-users at lists.osgeo.org
> Subject: [mapguide-users] RE: MGE performance. It's soooooo
> Slllllllooooooowwww
> 
> 
> Thanks for the much appreciated responses to this issue.   Here's a
little
> more background information as to why we want to use the flexable web
> layouts and not the Ajax viewer.
> 
> -  The floating task panes are a very big thing for us especially to
> display
> our reports to our end users.
> -  Thematic layers (queries)
> -  As Gord mentioned the open layers
> 
> We are trying to replicate as best we can the enviorment we currently
> offer
> our MG users, since to remove any that is used so much would be a step
> back
> not a step forward.
> 
> I did go through the 'Mapguide Best Practices' wiki since making this
> initial post and made a few changes that really helped with performance
> after getting the heads up for Gord.
> 
> - Setting the cache properly
> - changing png to png8
> - etc.
> 
> Those did make a noticable difference.
> 
> We also moved all our external datasources (sdf's, raster images) to the
> server that houses the MGE server.  Previously they were on a seperate
> network server, I'm not sure if that actually had something to do with
the
> improved performance or not.
> 
> -  I'm also going through our datasources we have and importing the data
> into the SDF3 as was suggested so that it limits the amount of data that
> is
> loaded from the SQL db.  That's not an ideal situation since most users
> have
> been trained to see live dynamic data for any db changes they make, but
> for
> datasets where having the data update nightly isn't an issue then I'll
> make
> that adjustment.
> 
> I do have a few questions about some of the posts made:
> 
> - indexing the geometry, that only works if all the x,y's are unique.
I'm
> not confident that will be possible for all our SQL data.
> - and there is alot of talk about the amount of layers loaded.
> Previously
> in 6.5 we could load more data and as such we did.  We have limited how
> much
> is turned on by default, the question I have about the layers and scales
> is
> I didn't think it would necessary for MGE.
> 
> What I mean is, if we have say a parcel layer.  How can that be
> generalized
> anymore than it is?  So in studio I have a parcel layer that is set to a
> scale of 0 to 20,000.  Introducing more scales against that same data
> resource used to create that layer, would that actual speed it up
because
> it's loading the same data set at different scales?  Since the dataset
is
> the same, applying multiple scales to it in the styles of MGES should
have
> no effect.
> 
> -  We have themed layers as well that are very slow.  The themed layers
> are
> joined layers which hit the SQL db to return the data.   They are
> extremely
> slow, how are the themed layers being addressed to help with the
> performance?  Themed layers are what makes the GIS powerful.
> 
> We currently use:
> IIS ver 6
> MGE 2011
>   -  Map data is sdf, dwf (bbboooo, hiss), and SQL 2005
>   -  raster tiff and ecw
>   -  secondary data from SQL
>   -  using tooltips but using the iframe that accompanies the openlayers
> concept and fusion to load aspx pages instead.  (that is not always
fast)
>   -  .Net and VB
> 
> Thanks for the info, please keep it coming this is great.
> --
> View this message in context:
http://osgeo-org.1803224.n2.nabble.com/MGE-
> performance-It-s-soooooo-Slllllllooooooowwww-tp5970714p5971384.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