comparison geo-backend/ChangeLog @ 541:3cbf11c67fdc

Experimental caching of SQL results via Ehache geo-backend/trunk@462 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 18 Dec 2009 16:13:52 +0000
parents 27082b83c267
children f0b6d0e2a0f6
comparison
equal deleted inserted replaced
385:27082b83c267 541:3cbf11c67fdc
1 2009-12-171 Sascha L. Teichmann <sascha.teichmann@intevation.de> 1 2009-12-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2
3 Experimental caching of SQL results via Ehache
4
5 * pom.xml: Added dependency to Ehcache
6
7 * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutor.java:
8 Extended interface to support caching by SQL statements as Strings.
9
10 * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutorBase.java:
11 Implements new interface with no caching
12
13 * src/main/java/de/intevation/gnv/geobackend/base/query/container/QueryContainerFactory.java:
14 synchronized access to singleton.
15
16 * src/main/java/de/intevation/gnv/geobackend/base/query/DefaultQueryExceutor.java:
17 calls caching methods of base class.
18
19 * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutorFactory.java:
20 When system property 'query.executor.factory' is given the value is used as
21 a class name to be instantiated as a sub class of QueryExecutorFactory.
22 This happens if the singleton of QueryExecutorFactory is created. With the
23 mechanism it is possible to replace the standard behavior of creating QueryExecutors.
24
25 * src/main/java/de/intevation/gnv/geobackend/base/query/CachingQueryExecutorFactory.java:
26 New: This class extends QueryExecutorFactory and can be used as replacement for
27 the standard QueryExecutorFactory. Usage:
28
29 -Dquery.executor.factory=de.intevation.gnv.geobackend.base.query.CachingQueryExecutorFactory
30
31 If you pass in another system property 'caching.query.executor.config' you can
32 customize the caching. The value is used as a file name to an XML file with
33 Ehcache configuration.
34
35 * contrib/sql-cache.xml: Demo configuration for sql caching. Usage:
36
37 -Dquery.executor.factory=de.intevation.gnv.geobackend.base.query.CachingQueryExecutorFactory
38 -Dcaching.query.executor.config=contrib/sql-cache.xml
39
40 2009-12-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2 41
3 RELEASE 0.3 42 RELEASE 0.3
4 43
5 * Changes, NEWS, ChangeLog: Summarized changes. 44 * Changes, NEWS, ChangeLog: Summarized changes.
6 45

http://dive4elements.wald.intevation.org