view flys-backend/doc/schema/oracle-drop-spatial.sql @ 5779:ebec12def170

Datacage: Add a pool of builders to make it multi threadable. XML DOM is not thread safe. Therefore the old implementation only allowed one thread to use the builder at a time. As the complexity of the configuration has increased over time this has become a bottleneck of the whole application because it took quiet some time to build a result. Furthermore the builder code path is visited very frequent. So many concurrent requests were piled up resulting in long waits for the users. To mitigate this problem a round robin pool of builders is used now. Each of the pooled builders has an independent copy of the XML template and can be run in parallel. The number of builders is determined by the system property 'flys.datacage.pool.size'. It defaults to 4.
author Sascha L. Teichmann <teichmann@intevation.de>
date Sun, 21 Apr 2013 12:48:09 +0200
parents 8b29a94ebdd8
children
line wrap: on
line source
DROP TRIGGER river_axes_trigger;
DROP TABLE river_axes;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES';
DROP SEQUENCE RIVER_AXES_ID_SEQ;

DROP TRIGGER river_axes_km_trigger;
DROP TABLE river_axes_km;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'RIVER_AXES_KM';
DROP SEQUENCE RIVER_AXES_KM_ID_SEQ;

DROP TRIGGER cross_section_tracks_trigger;
DROP TABLE cross_section_tracks;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CROSS_SECTION_TRACKS';
DROP SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;

DROP TRIGGER buildings_trigger;
DROP TABLE buildings;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'BUILDINGS';
DROP SEQUENCE BUILDINGS_ID_SEQ;

DROP TRIGGER fixpoints_trigger;
DROP TABLE fixpoints;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FIXPOINTS';
DROP SEQUENCE FIXPOINTS_ID_SEQ;

DROP TRIGGER floodplain_trigger;
DROP TABLE floodplain;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODPLAIN';
DROP SEQUENCE FLOODPLAIN_ID_SEQ;

DROP TRIGGER dem_trigger;
DROP TABLE dem;
DROP SEQUENCE DEM_ID_SEQ;

DROP TRIGGER catchment_trigger;
DROP TABLE catchment;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'CATCHMENT';
DROP SEQUENCE CATCHMENT_ID_SEQ;

DROP TRIGGER hws_lines_trigger;
DROP TABLE hws_lines;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_LINES';
DROP SEQUENCE HWS_LINES_ID_SEQ;

DROP TRIGGER hws_points_trigger;
DROP TABLE hws_points;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HWS_POINTS';
DROP SEQUENCE HWS_POINTS_ID_SEQ;

DROP TRIGGER floodmaps_trigger;
DROP TABLE floodmaps;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOODMAPS';
DROP SEQUENCE FLOODMAPS_ID_SEQ;

DROP TRIGGER hydr_boundaries_trigger;
DROP TABLE hydr_boundaries;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES';
DROP SEQUENCE HYDR_BOUNDARIES_ID_SEQ;

DROP TRIGGER hydr_boundaries_poly_trigger;
DROP TABLE hydr_boundaries_poly;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'HYDR_BOUNDARIES_POLY';
DROP SEQUENCE HYDR_BOUNDARIES_POLY_ID_SEQ;

DROP TRIGGER gauge_location_trigger;
DROP TABLE gauge_location;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'GAUGE_LOCATION';
DROP SEQUENCE GAUGE_LOCATION_ID_SEQ;

DROP TRIGGER jetties_trigger;
DROP TABLE jetties;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'JETTIES';
DROP SEQUENCE JETTIES_ID_SEQ;

DROP TRIGGER flood_marks_trigger;
DROP TABLE flood_marks;
DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'FLOOD_MARKS';
DROP SEQUENCE FLOOD_MARKS_ID_SEQ;

DROP TABLE hws_kinds;
DROP TABLE sectie_kinds;
DROP TABLE sobek_kinds;
DROP TABLE fed_states;
DROP TABLE axis_kinds;
DROP TABLE boundary_kinds;
DROP TABLE cross_section_track_kinds;
DROP TABLE floodplain_kinds;
DROP TABLE building_kinds;

http://dive4elements.wald.intevation.org