On Fri, Nov 23, 2012 at 2:48 AM, cmaul <christian.m...@dse.vic.gov.au>wrote:
> Paul,
>
> as far as I see your data are static. You will not need them once you have
> created the tiles.
> My experience is that databases require 4 -10 times more time to render a
> layer than local shape files.
>
My experience on shapefiles vs databases is a bit more articulated than
that.
If all I'm trying to do is to render a whole large dataset in a relatively
small image
(which normally results in a "cloud" of superimposed geometries) then yes,
shapefiles
are visibly faster.
Benchmarks showed on the other side that if we try to always get a very
small
portions of a large dataset we get better performance out of PostGIS than a
shapefile
instead (probably due to the better spatial index).
Where database win hands down is with styles that have feature selection
based
on attributes, such as having a road network, and displaying only highways
at lower
scales, because the db can have an index on that attribute, whilst the
shapefile
data store cannot handle that
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users