On Mon, Aug 20, 2012 at 3:13 AM, cheesybiscuits <[email protected]>wrote:
> I agree that there is value in limiting what is rendered, but my current > concern is whether what I'm seeing performance-wise indicates a problem in > my GeoServer setup or is just normal behaviour. If there is an issue, and > 130,000 should render quicker, then I might still see sub-optimal rendering > even with 10,000 points. Perhaps the current data volume is helping to > highlight an issue with my server that is less apparent at lower volumes. > > Once I am have a clear idea what is going on I will look at reducing what > is > rendered. > I've just downloaded the wind dataset from here: http://www.spc.noaa.gov/gis/svrgis/ It's a point shapefile with 320000 points, so it makes a good test case I guess. I've tried to render it with the plain "red square" point style that comes built-in with GeoServer, in a map showing the whole data set (a sample is attached). Using different data sources I got the following timings (per request): Shapefile: 0.35s PostGIS with prepared statements: 4.5s PostGIS without prepared statements: 4.5s Oracle XE: 6.3s As usual shapefile is a lot faster than any other type of data source when loading the whole data set, but my timings seem to be a lot better than yours, especially given that I have a daset that is around 3 times bigger. My machine is nothing special, a workstation with core i7 860, 8GB of memory, Ubuntu 10.04 The tests were repeating using "ab" (apache bench) so the data gets fully loaded in memory, but that should be the case for you as well, 100k points should be a shapefile of just a few MB, by the time you make 2-3 requests to it the OS should cache the data blocks making it up in memory. The timings would change if I had to apply thematic mapping rules to the data though, maybe that's the slow part? 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 962313 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it -------------------------------------------------------
<<attachment: topp-wind-shp-nq8.png>>
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
