Questions regarding using database caching layer to increase performance
Questions tagged [database-caching]
25 questions
1
vote
1 answer
Codeigniter Web Page Caching and Database Caching both?
I am still new into Codeigniter framework. Today I read about Database Caching http://codeigniter.com/user_guide/database/caching.html and Web Page Caching http://codeigniter.com/user_guide/general/caching.html.
I am a bit confused if database…
JohnyFree
- 1,319
- 3
- 22
- 35
0
votes
0 answers
Dynamic Fields and Table Cache in Apache Ignite In-Memory Database
I am implementing the Apache Ignite In-Memory Database in sync with external Database (Primary DB) for spring boot application. In that How can I create a cache for dynamic entities from table that is present in the Primary DB for SQL queries that…
spatil
- 1
0
votes
1 answer
Mongodb Memory engine vs Redis for caching the writes
I have a server for processing the users' page viewing history with Mongodb.
The collections are saved like this when a user views a page
view_collection
{ "_id" : "60b212afb63a57d57a8f0006",
"pageId" : "gh42RzrRqYbp2Hj1y",
"userId" :…
Bright Chip
- 31
- 1
- 4
0
votes
0 answers
Cache mechanism for Pug Template (avoiding file system)
I'm using pug template engine. I want to cache the pug templates using a database (postgreSQL). The pug templates will have other pug templates included, hence on fetching the parent pug from the cache, included pug files should also be returned.…
jindal
- 1
0
votes
0 answers
How to increase performance of audit tables?
PROBLEM
Audit triggers are killing the performance of my bulk update query, by inserting an old row and a new row on every update.
In this trigger the insert of old rows, for some reason, takes much more time than inserting the new rows.
TABLE
The…
Nelssen
- 1,023
- 1
- 17
- 42
0
votes
1 answer
How to force mysql to cache a query for a specific period of time?
is there a way to force mysql to cache a particular query, for say 5 minutes, so executing that query will always return the same result even if the underlying db changes ?
i'm running a dating site and i have a page that shows "newest matches" and…
Sherif Buzz
- 1,218
- 5
- 21
- 38
0
votes
0 answers
Sample application for implementation of Guava Cache and Spring for Database caching
Firstly I am totally new to Guava cache and Spring as well, I had searched more 50 sites but could not get, what I was looking for. I am searching for implementation of guava cache for caching database values using spring.
Also, previously I had…
Bhargav Modi
- 2,605
- 3
- 29
- 49
0
votes
1 answer
SELECT + INSERT + Query Cache = MySQL lock up
MySQL server seems to constantly lock up and stop responding on certain types of queries and eventually (after couple of minutes of not responding) give up with an error "MySQL server has gone away", then hang again on the next set of queries, again…
dezlov
- 840
- 8
- 20
0
votes
3 answers
Cache the database content in memory to increase performance
I have a message driven bean running on Glassfish. It receives hundreds of messages per second. After receiving a message, it needs to read the values in the JDBC database and process.
However, the values in database will only be updated one time a…
zhushp
- 1
- 2
-3
votes
1 answer
Caching with php file
I am creating a php script with simple coding. I don't have much knowledge about caching. But have heard that there are object caching, Database Caching which will improve load time.
e.g., I have a sample php query, how can I enable database…
user3146425
- 25
- 2
- 9