52North/SOS — pull request #73 by CarstenHollmann (2014-07-17 12:55:41+00:00)
Title: Feature/move sampling geometry observation table

Move the samplingGeometry, used for the Spatial Filtering Profile) storage from spatialFilteringProfile table (geom) to observation table (samplingGeometry). This improves performance when the samplingGeometry is stored in the database because not joins are necessary and it is not required to query the samplingGeometry separately.
The old samplingGeometry handling is still supported by checking 'Old Spatial Filtering Profile' at the 'Datasource configuration' installation page.
In the /misc/db folder you can find update scripts for the supported DBMS to create the new column, copy the geometries from the spatialfilteringprofile table and drop the spatialfilteringprofile table.