Hi, I want to use a GeoServer to display a large collection of spatial data, stored in an oracle database (~4 million features spreaded on a radius of 150 miles). I added the database as a data source (oracle plugin) and added a layer to publish the data. The layer preview with openlayers usually fails after 60 seconds, because thats the preconfigured maximum rendering time (i also tried to set the time to 180 seconds, also without success).
So i tried to add a cached layer and to fill the cache through the generate-function. Some of the generated pictures in the cache show the correct data, but most of the pictures in the cache are just black, because the rendering fails again after 60 seconds. If i reduce the features to a few hundred feaures everything works fine. If I export the features to a big shapefile and publish the shapefile everything is ok, but the features can change everyday and i can't export all the features everyday. I think i'm doing sth. completely wrong, a lot of wms-servers have these amounts of features and don't face any problems. I wonder why publishing a big shapefile is really fast and publishing the same data from an oracle server (in the same intranet) is such a big deal for me. Can i reduce the features to render on a lower zoom level? Why is this a problem if loaded from a database and no problem if loaded from a shapefile? Thanks for your effort, Frank -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Problems-with-large-amount-of-features-from-Oracle-DB-tp5139088.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
