Hi Andrea,
Thanks a lot for your quick answer.
I have just disabled the "native paging", but still that line of the query
(I mean "select top 100000" part) remains there. I tried to use exactly the
same query in SQL server, I mean:
SELECT count(*) FROM (SELECT * FROM
[JRC_EURDEP_PUBLIC_DM].[dbo].[fn_LastANDMaxDoseRateHourlyAverages_3]
('2015-02-13','2015-03-13 13:00')
) as "vtable"
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 "vtable2"
and that seems to be slower, so most likely removing the SELECt TOP 100000
should improve the things.
Is there any other way for removing native paging?
Regards, Luca
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/slow-perfromance-with-SQL-parametric-view-tp5194921p5194967.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
