we are rendering many points from the SQL db. where our each row is having
one column(json) which contains Lat and long. In sql views we have given
this query to render our datasets
SELECT Id,Type,JSON_VALUE(ObjJson,'$.Details.Name.Value') AS
ObjName,geometry::STGeomFromText('POINT(' +
CAST(JSON_VALUE(ObjJson,'$.Details.Longitude.Value') AS CHAR(20))+ ' ' +
CAST(JSON_VALUE(ObjJson,'$.Details.Latitude.Value') AS CHAR(20)) + ')',4326)
AS geometria FROM dbo.Objects WHERE Type='Carr'
- when we added 300 rows means 300 points its was working fine.
- As we have added more than 80000 rows means 80000 points its getting too
much hang.
- please, can anyone tell how shall I make use of the geoserve to render
more than 300000 points and each point will be able to update and delete?
- At client side i am using openlayer to show the wms layer.
- How to pass dynamic sql query to filter the points from one layer
--
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
