[mapguide-users] using views

[Jonathan Rizzo]

Hello List,

I have a site which I created using SQL Server 2008 to store all of the data.  The site works great, but one operation seems to be particularly slow.  I created a view to join a polygon feature source with some other database data, and I use that view to define my layer.  This works, but is extremely slow.  It can take anywhere from 2-9 seconds to query the layer, depending on server loadSQL Server is telling me that the offending query is just a SELECT statement which calls [geom].STIntersects in the 'WHERE' clause (presumably to find all of the polygons within the extents of the map).  .  The table contains less than 1000 polygons, and the query should select less than 100 of them.

I KNOW that joins like this are a performance issue with MapGuide, but I was wondering if there are any "best practices" documented anywhere to improve performance to the maximum extent possible, such as how to define any indexes.  Any suggestions would be greatly appreciated.

Thanks,

Jon

Jonathan Rizzo
Senior Applications Developer
Direct: 201.398.4650
Mobile: 551.206.5782
Fax: 201.398.4850

Langan Engineering & Environmental Services
Phone: 201.794.6900   Fax: 201.794.0366
619 River Drive Center 1
Elmwood Park, NJ 07407-1338
www.langan.com <http://www.langan.com>

Langan's goal is to be SAFE (Stay Accident Free Everyday)

NEW JERSEY   NEW YORK   CONNECTICUT   PENNSYLVANIA   VIRGINIA   FLORIDA   CALIFORNIA
ABU DHABI   ATHENS   DOHA   DUBAI   ISTANBUL

Please consider the environment before printing this e-mail
This electronic transmission may contain confidential, proprietary or privileged information. No confidentiality or privilege is intended to be waived or lost by erroneous transmission of this message. If you receive this message in error, please notify the sender immediately by return email and delete this message from your system. Disclosure, use, distribution or copying of this message, any attachments thereto or their contents is strictly prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20120802/9f0e0f09/attachment.html>