@ Canduc17<br><br>I have a postGIS layer with 250000 records and not have the same problem.<br>I have split the postGIS layer into two "tables" one table pure geometry and other table attribute data.<br><br>I get a specific extent from the user and only display that extent in a tile, I don't load the entire postgis layer, the user might not be interested in the entire layer but only a spefiic area, so maybe try and get a location from the user which the user want to display/see.<br>
<br>My solutions is based on my database structure, your might be different.<br><br clear="all">Sarel Coetzer | GIS Developer<br><br>Malaria Research Programme<br>Medical Research Council<br>Tel : 031 203 47 94<br><a href="http://www.malaria.org.za/">http://www.malaria.org.za/</a><br>
<br>
<br><br><div class="gmail_quote">On Mon, Nov 28, 2011 at 11:33 AM, canduc17 <span dir="ltr"><<a href="mailto:candini@meeo.it">candini@meeo.it</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Starting from <a href="http://openlayers.org/dev/examples/all-overlays.html" target="_blank">http://openlayers.org/dev/examples/all-overlays.html</a> this<br>
example , I've written the following piece of code:<br>
I have a server side loop (Django syntax) which retrieves all the features<br>
of a dataset from a Postgis database, in GeoJSON format.<br>
The script works fine, but the problem is the quantity of features: I have<br>
11000 features, which means a final html file 9.3MB big and the need for the<br>
browser of 555 MB of memory.<br>
It loads everything after 10 seconds and map navigation is almost<br>
impossible, due to processor elaboration for pan/zoom and memory<br>
consumption.<br>
How can I manage this? Is there any OpenLayers tool which I can use to<br>
minimize resource consuption?<br>
Or should I use another approach, for example producing little png server<br>
side and load them instead of vector features?<br>
Any suggestion would be really appreciated, thanks in advance.<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/How-to-manage-huge-amount-of-vector-features-tp7038117p7038117.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/How-to-manage-huge-amount-of-vector-features-tp7038117p7038117.html</a><br>
Sent from the OpenLayers Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.osgeo.org">Users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/openlayers-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/openlayers-users</a><br>
</font></span></blockquote></div><br>