Hi, I am using GeoServer with MSSQL DataStore. The table contains billions of record and keeps going on increasing. Currently table Structure is ID:nvarchar, Name:nvarchar, Lat:nvarchar, Long:nvarchar, geom:geometry
where geom column is SQL spatial_index.But still, request from Openlayer result taking 10 to 15 second in response. Earlier it was before applied Spatial Index on table query taking 40-50 second to process request. So I want the best way to process billions of data with GeoServer. Please guide me through the best approach to connect Sql Server with billions records in one table and render with GeoServer. -- Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
