Hi Christian, as Phil, I think the issue is less one of technology. Firstly, what Phil said implicitly: If the speed is that important tile the layer and access the tiles not the database. This eases speed problems that may come with a complicated styling, too. However, prefabricated tiles or tile sets (which are turned over according to a certain time scale) come with a currency problem. What is more important for you: Speed or currency. Think of accessing these tiles as WMTS, no bounding box no internal calculations which tile conforms to which slice of my picture, you go directly to the tile. Network. Any database sitting side-by-side with your server is faster than a remote one. Same as Phil, I found little differences between Oracle and PostGIS, with PostGis being a little bit faster. But then - no surprise here when the DB sits on the same disk. That will always beat what Phil called a 'serious iron', which sits on its own dedicated machine. Try to simplify filters and put them into one attribute even if that violates the normality rules. Index the DB, not just the spatial field.
Views will be faster than SLD filters. 'filter the datasources in geoserver with sql-querys', yes definitely, as far as I know they are essentially views but think also of materialized views, which are generally faster. However, you need to refresh your views, when you refresh the data. Make the symbols as small and simplified as you can i.e. jpg not png. If you need transparency you're stuck with png. More important than your technology choice will be the way you structure your data, chop up the sld (if possible), indexes, styling and tiling. 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.x6.nabble.com/Which-data-source-for-geoserver-is-fastest-tp5068356p5068562.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
