Pretty standard question, but do you have any indexes on the data?<br><br><div class="gmail_quote">On Fri, May 21, 2010 at 3:27 PM, Yurka <span dir="ltr"><<a href="mailto:yuratsebro@gmail.com">yuratsebro@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><br>
Well it may sound weird but the data is stored in MYSql ...<br>
Transfer to PostGIS was my next step to try.<br>
<br>
If i understood you correctly,<br>
in my case its impossible to use views since some of the input comes from<br>
user.<br>
<br>
<br>
I will try to use singe tiled WMS see if its better.<br>
Thanks for quick response,<br>
<br>
-y<br>
<font color="#888888">--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/Large-Dataset-tp5085920p5085981.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/Large-Dataset-tp5085920p5085981.html</a><br>
</font><div><div></div><div class="h5">Sent from the OpenLayers Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@openlayers.org">Users@openlayers.org</a><br>
<a href="http://openlayers.org/mailman/listinfo/users" target="_blank">http://openlayers.org/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br><div style="visibility: hidden; display: inline;" id="avg_ls_inline_popup"></div><style type="text/css">#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 13px;}</style>