I am redirecting your question to the geotools user list, the developer
list is for those working on the geoserver codebase.
For more information see our website <http://geoserver.org/comm/> page on
communication.
--
Jody Garnett
On Sat, 2 Jun 2018 at 08:33, C.Ram <[email protected]> wrote:
> 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.
>
> 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-Dev-f3819232.html
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Geoserver-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
GeoTools-GT2-Users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
