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

Kemahiran: Kejuruteraan, Java, Kejuruteraan Perisian

Lihat lagi: 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

Tentang Majikan:
( 10 ulasan ) London, United Kingdom

ID Projek: #15820717

3 pekerja bebas membida secara purata $154 untuk pekerjaan ini



$150 USD dalam 10 hari
(171 Ulasan)

View my last projects based on Data Mining, Artificial Intelligence, java, Engineering, Software Architecture and I can complete your project perfectly. www.freelancer.com/u/vorasiddh4it#/reviews Relevant Skills and E Lagi

$200 USD dalam 10 hari
(23 Ulasan)

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

$111 USD dalam 5 hari
(0 Ulasan)