Mercurial > dive4elements > river
comparison flys-backend/ChangeLog @ 478:db430bd9e0e0
Implemented a WstColumnValue cache to speed up inserting WST files into database.
flys-backend/trunk@1734 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 20 Apr 2011 07:21:03 +0000 |
| parents | 0addc2663a4d |
| children | f9653fc8ef7b |
comparison
equal
deleted
inserted
replaced
| 477:0addc2663a4d | 478:db430bd9e0e0 |
|---|---|
| 1 2011-04-20 Ingo Weinzierl <ingo@intevation.de> | |
| 2 | |
| 3 * src/main/java/de/intevation/flys/importer/WstColumnValueKey.java: | |
| 4 New. This class is used as distinct key of a WstColumnValue - e.g. as | |
| 5 key in a map. | |
| 6 | |
| 7 * src/main/java/de/intevation/flys/importer/ImportWst.java: A | |
| 8 WstColumnValue cache is build up while initialization. This cache | |
| 9 contains all WstColumnValues that exist in the database. | |
| 10 | |
| 11 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java: New | |
| 12 constructor that takes the WstColumnValues cache. It is used to | |
| 13 initialize new ImportWstColumnValue objects. | |
| 14 | |
| 15 * src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java: | |
| 16 Speedup: A ImportWstColumnValue has a WstColumnValues cache that | |
| 17 contains all WstColumnValues existing in the database. This makes it | |
| 18 unnecessary to call an sql statement for each WstColumnValue to | |
| 19 determine its existence in the database. | |
| 20 | |
| 1 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de> | 21 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de> |
| 2 | 22 |
| 3 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql: | 23 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql: |
| 4 Added a view 'wst_value_table' which aggregates the data | 24 Added a view 'wst_value_table' which aggregates the data |
| 5 to build w/q value tables. | 25 to build w/q value tables. |