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. PostGIS is among the faster DBs and would be at the lower end of the 4 - 10, but not that fast that it could compete with shapes.
If your region of interest isn't that big you shouldn't run into problems with space for the shape files. However, I would approach it the other way round: pixel size at the lowest scale is x.x mm a 256*256 tile covers thus y.y square metres which means you need z.z million of tiles for your bounding box, double that for all scales and that is the number you need to cut. A day has 86400 seconds and to get it done in x time you would need x tiles per second, which would be your target. Then cut the first ten levels and have a look. Or if you have it as one job in geowebcache, you will get a rough estimate about the tile number to be cut. If you can afford the time with a database then do it if not then use the shapes. Between the table and the view I would expect only marginal differences. Cheers Christian ----- ____________________________ Dr Christian Maul Project Manager Information Services Branch Department of Sustainability and Environment Level13, Marland House, 570 Bourke Street Melbourne 3000 PO Box 500, East Melbourne Vic 3002 Telephone: +61-3-8636 2325 Telefax: +61-3-8636 2813 -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Performance-question-tp5017873p5018261.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ 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
