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

Andrea Aime created BugGEOS-6005
GeoServer re-computes sql-view feature type structure for each request

Issue Type:

BugBug

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:

MajorMajor

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](http://www.atlassian.com/software/jira)