Hi, find my 2 cents inline, while waiting for suggestions from more expert guys
and of course look at http://www.slideshare.net/geosolutions/geoserver-on-steroids by Andrea Aime and Simone Giannecchini 2013/2/20 dkotian95 <[email protected]>: > Hi, > > I have a huge amount of Vector data that I would like to serve via > geoserver, data size would be around 300 GB covering an area of 1/5th of the > U.S. > There are around 60-70 odd layers and all this data, I would like to serve > via WMS and there are SLDs to be applied to the layers for roads,point > symbology using SVGs. > > Question: > 1. I can create shape files(.shp) for this data or put it into oracle > spatial , which one would give better performance if we publish via Oracle > Spatial datastore or publish via Shapefile datastore for all these vector > layer. I understand that shape file has a limitation of 2GB,I will somehow > manage to restrict the size to 2GB or increase the layers. shapefile is usually faster, but if you have to split layers probably Oracle or PostGIS is a better choice. By the way spatial option requires Oracle Enterprise edition , that is big bucks to put on the project budget. Consider using Locator, you don't need spatial for storing data in SDO_GEOMETRY, or better have a look at PostGIS. > > 2. We have around 25-30 concurrent users as well on this and would increase > in future, what would be better(shp or oracle) > > 3. Do we really need tile caching for these vector layers or we can bypass > it and serve directly from geoserver at all the time if we use shape file? Using shapefile or Oracle I would use GeoWebCache anyway. The only reason against caching your data is if they are updated very frequently. > > 4. Are there any Oracle connecting/buffering tweaks on Geoserver recomended > for these kind of large datasets. > > > Kindly suggest. > > > best Regards > dk > Kind Regards, Stefano --------------------------------------------------- 41.95581N 12.52854E http://www.linkedin.com/in/stefanoiacovella http://twitter.com/#!/Iacovellas ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
