<div><div>Well it certainly sounds like you are doing the right things...</div><div> </div><div>Unfortunately, though it means that your analysis may be entirely correct in that the join between the shapefile and the database is just too slow to display the color coding when zoomed out.</div>
<div> </div><div>Don't know what tools you have access to and what your join looks like but you may want to make sure that there are indexes on join columns and filter columns (in both the database and shape) to ensure the fastest possible response. As well, if you can create a view in your database with the minimal columns required for the theming that may help some too.</div>
<div> </div><div>Since I am assuming you are using unmanaged data sources (ie not load procedures), do you have any way to generalize the shape polygons to make the processing simpler?</div><div> </div><div>Jonathon<br><br>
</div></div><div class="gmail_quote">On Tue, Jun 7, 2011 at 5:18 AM, jamsea <span dir="ltr"><<a href="mailto:thejamsea@gmail.com" target="_blank">thejamsea@gmail.com</a>></span> wrote:<br><blockquote style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;" class="gmail_quote">
I tried stopping the mapguide service and apache, deleting the IDX files,<br>
then starting apache and mapguide but I'm still having the same problem. The<br>
geometry in the shape files is good too. I double checked my database for<br>
null values, how do you check the shape files for null values?<br>
<br>
All the features on my map are shown when I pan, its just the colour coding<br>
is missing at larger scales (e.g zoomed at 1:500 everything looks great,<br>
zoomed out to 1:1000 everything changes to the default colour). The database<br>
is what holds the fields needed for colour coding, so I think mapguide just<br>
isn't querying the database when there are too many points on the screen.<br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Layer-Rule-not-Rendering-at-Assigned-Layer-tp6435900p6449278.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/Layer-Rule-not-Rendering-at-Assigned-Layer-tp6435900p6449278.html</a><br>
</font><div><div></div><div>Sent from the MapGuide Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div></div></blockquote></div><br>