[OpenLayers-Users] How to manage huge amount of vector features

[S Coetzer]

@ Canduc17

I have a postGIS layer with 250000 records and not have the same problem.
I have split the postGIS layer into two "tables" one table pure geometry
and other table attribute data.

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.

My solutions is based on my database structure, your might be different.

Sarel Coetzer | GIS Developer

Malaria Research Programme
Medical Research Council
Tel : 031 203 47 94
http://www.malaria.org.za/



On Mon, Nov 28, 2011 at 11:33 AM, canduc17 <candini at meeo.it> wrote:

> Starting from  http://openlayers.org/dev/examples/all-overlays.html this
> example , I've written the following piece of code:
> I have a server side loop (Django syntax) which retrieves all the features
> of a dataset from a Postgis database, in GeoJSON format.
> The script works fine, but the problem is the quantity of features: I have
> 11000 features, which means a final html file 9.3MB big and the need for
> the
> browser of 555 MB of memory.
> It loads everything after 10 seconds and map navigation is almost
> impossible, due to processor elaboration for pan/zoom and memory
> consumption.
> How can I manage this? Is there any OpenLayers tool which I can use to
> minimize resource consuption?
> Or should I use another approach, for example producing little png server
> side and load them instead of vector features?
> Any suggestion would be really appreciated, thanks in advance.
>
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/How-to-manage-huge-amount-of-vector-features-tp7038117p7038117.html
> Sent from the OpenLayers Users mailing list archive at Nabble.com.
> _______________________________________________
> Users mailing list
> Users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/openlayers-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20111128/1170f432/attachment-0001.html