Sorry Andrea, my mistake,
now there is anymore the "SELECT TOP 100000" part but still remains the
first line of the query:
SELECT count(*) FROM (SELECT * FROM
[JRC_EURDEP_PUBLIC_DM].[dbo].[fn_LastANDMaxDoseRateHourlyAverages_3]
('2015-02-13','2015-03-13 13:00')
Unfortunately this line is an overhead for the performance issue, is there
any chance to get rid of it?
regards, Luca
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/slow-perfromance-with-SQL-parametric-view-tp5194921p5194977.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
