Hi all,
I have a very complex query in a SQL server DB from which to grab features
for delivering a WFS.
I tried using SQL parametric view in Geoserver but unfortunately the
performance are very poor, while the query is fast enough if executed inside
SQL environment.
So the SQL part is improved at its best, the target now is to find a
suitable solution for delivering my
data as WFS but with good performance.
Do you have any suggestions about solving such issue?
One thing I thought is to split my data in the DB so that the access would
be faster, but of course I would need to instruct GeoServer about what data
to deliver according the WFS parameters, maybe I could use Geoscript for
shifting all logic about which data to consider. Is geoscript able to build
a WFS service?
Thanks a lot in advance.
Below you can find the log of geoserevr about one call with SLQ parametric
view:
2015-03-23 10:33:00,482 INFO [org.geoserver.wfs] -
Request: getServiceInfo
2015-03-23 10:33:00,484 INFO [org.geoserver.wfs] -
Request: getFeature
service = WFS
version = 1.0.0
baseUrl = http://localhost:8080/geoserver/
query[0]:
typeName[0] = {eurdep.jrc.ec.europa.eu}testMaxAvg
outputFormat = application/json
resultType = results
2015-03-23 10:33:00,486 INFO [org.geoserver.wfs.json] - about to encode JSON
2015-03-23 10:33:00,486 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2015-03-23 10:33:00,488 DEBUG [org.geotools.jdbc] - SELECT count(*) FROM
(SELECT * FROM
[JRC_EURDEP_PUBLIC_DM].[dbo].[fn_LastANDMaxDoseRateHourlyAverages_3]
('2015-02-13','2015-03-13 13:00')
) as "vtable"
2015-03-23 10:33:01,246 DEBUG [org.geotools.util] -
InterpolationConverterFactory can be applied from Strings to Interpolation
only.
2015-03-23 10:33:01,247 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
2015-03-23 10:33:01,247 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
2015-03-23 10:33:01,248 DEBUG [org.geotools.jdbc] - SELECT top 100000
"StationCode","Country","GeoLocation".STAsBinary() as
"GeoLocation","LastAverage","MaxAverage" FROM (SELECT * FROM
[JRC_EURDEP_PUBLIC_DM].[dbo].[fn_LastANDMaxDoseRateHourlyAverages_3]
('2015-02-13','2015-03-13 13:00')
) as "vtable"
2015-03-23 10:33:01,900 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/slow-perfromance-with-SQL-parametric-view-tp5194921.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
