in-memory caching - Result Caching Cache

We are working on reporting tool. the purpose of the tool is simply visualising the data from underlying database. Although the basic functionality work; the challenges we face is when the query is executed multiple times it's slows down the performance.

What we plan to achieve is below

1. A Query executed from frontend reporting layer; the query will be bring the results from underlying database (postgresql)

2. The query results should be cached in memory layer (should be a open source technology)

3. When the same query is executed again the data should be fetched from result set cache rather than getting data from database

4. If the underlying data changed in database than result set should purge and new data should be fetched from database and cached in-memory; meaning the data in cache should be consistant with database

5. Should be able to filter from query results.

6. The cached results should never exceed the memory.

7. There should be a time out for every cached query so that we can clear the cache periodically.

8. We need to have an option to either cache the query or not

9. Any suggestions or improvements are welcome

What we provide is:

1) We will be providing a commons library we built for you to know the kind of object you would be receiving from the Application layer.

2) An developer environment (Amazon Workspace) with all the necessary tools installed

Please refer to the attachment

Evner: Ingeniørarbejde, Java, Software Arkitektur

Se mere: in memory cache c#, memorycacheentryoptions, what is in memory cache, in memory cache tools, imemorycache, in memory cache database, microsoft.extensions.caching.memory example, in memory cache vs database, 2048k memory used caching accepting requests, 2048k memory used caching, leverage browser caching total cache, wordpress leverage browser caching working, caching super cache, webkit without caching memory leak, cache control prevent caching php, meta prevent html caching cache store, php html prevent caching, html pragma prevent caching flash, creloaded cache working, prevent caching flash

Om arbejdsgiveren:
( 10 bedømmelser ) London, United Kingdom

Projekt ID: #15820717

3 freelancere byder i gennemsnit $154 på dette job



$150 USD in 10 dage
(171 bedømmelser)

View my last projects based on Data Mining, Artificial Intelligence, java, Engineering, Software Architecture and I can complete your project perfectly. Relevant Skills and E Flere

$200 USD in 10 dage
(23 bedømmelser)

I can give better way caching with redis cache technology and auto updates from db.

$111 USD in 5 dage
(0 bedømmelser)