[mapguide-users] mapguide and mssql low performance problem

[Scott Hameister]

Spatial Indexing is huge,  as was mentioned.
I know it makes no sense, but I found a layer once that had to many
Varchar(max) fields converting that one layer to the appropriate varchar
lengths made a difference.
Making sure that your layers are the same coordinate system as the map
helps.
Make sure you have a primary key.
If you are theming a layer make an index on the column you are theming as
well.
I've also notice tables with too many indexes seem to suffer as well.

On Mon, Jul 25, 2016 at 5:43 PM, RenoSun <renolionheart at gmail.com> wrote:

> Hi Abbasali,
>
> Did set up the spatial indexes for your mssql tables?
>
> Please see the following link to figure out the best spatial index setting
> for your data tables:
>
> The Black Art Of Spatial Index Tuning In SQL Server
> <
> http://boomphisto.blogspot.ca/2011/04/black-art-of-spatial-index-tuning-in.html
> >
>
> Your data tables are huge, and normally the performance of using mssql with
> mapguide is worse than using SQLite/SDF files.
>
> You may want to try to convert your mssql tables into SQLites spatial to
> see
> if mapguide will be able to load faster.
>
> Generalize the coordinates of your geometries will help too, but it will
> scarify a little bit accuracy. Like make your each coordinates to only 3
> decimal places. If you are using LL84, please keep at least 6-7 decimal for
> each coordinates.
>
> Don't join your mssql tables on mapguide or AIMS with other spatial tables,
> because it usually will make it slower or very slow.
>
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/mapguide-and-mssql-low-performance-problem-tp5276761p5278082.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




-- 


*Scott Hameister | www.mpowerinnovations.com
<http://www.mpowerinnovations.com/>________________________________________**mPower
Innovations*
1051 N Lynndale Drive, Suite 2A, Appleton, WI 54914
Main: (877) 269-6971 x 204 <%28877%29%20269-6971%20x%20207> | Mobile: (920)
419-6250 <%28920%29%20470-0292>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20160726/35cc181f/attachment.html>