[Geoserver-devel] [jira] (GEOS-6005) GeoServer re-computes sql-view feature type structure for each request

Wed, 28 Aug 2013 07:11:55 -0700

Issue Type: Bug Bug
Affects Versions: 2.4-RC1
Assignee: Andrea Aime
Created: 28/Aug/13 9:07 AM
Description:

Each WMS request causes the following to be logged when geotools-logging level is active:

28 ago 15:58:38 DEBUG [org.geotools.jdbc] - Gathering sql view result structure:
 select * from (SELECT st.obs_year,
                            st.storm_num,
                            st.storm_name,
                            min(st.obs_datetime)
                            AS storm_start, max(st.obs_datetime)
                            AS storm_end, max(st.wind)
                            AS max_wind, st_makeline(st.geom)
                            AS the_route
FROM ( SELECT storm_obs.storm_num,
                            storm_obs.storm_name,
                            storm_obs.wind,
                            storm_obs.press,
                            storm_obs.obs_datetime,
                            date_part('year'::text, storm_obs.obs_datetime)
                            AS obs_year, storm_obs.geom
       FROM storm_obs
      ORDER BY date_part('year'::text, storm_obs.obs_datetime),
                                    storm_obs.storm_num,
                                    storm_obs.obs_datetime) st
GROUP BY st.obs_year, st.storm_num, st.storm_name
ORDER BY st.obs_year, st.storm_num) as "vtable" where 1 = 0



Apparently the structure of the feature type is not cached within the jdbc data store
Project: GeoServer
Priority: Major Major
Reporter: Andrea Aime
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira 
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Reply via email to