The cache tag has no wiki summary.
0
votes
1answer
24 views
Why is LRU is not suitable for joining 2 relations in DBMS
In DBMS, can someone please explain how the LRU (least recently used) buffer replacement policy acts when joining 2 relations in a database?
I have read that LRU is not efficient when joining two ...
2
votes
0answers
45 views
Multithreading caching in SQL CLR
Is there any mechanism available to a SQLCLR assembly for caching that will still work when the assembly is registered as "safe"?
The cache needs to be thread-safe, so it can be shared by multiple ...
2
votes
0answers
35 views
Postgres caching and bytea
I have a DB which, among other things, stores images (as bytea, if that's interesting). It also stores users' metadata, activity logs, etc., but images currently take 500MB out of the total 600MB ...
1
vote
0answers
64 views
Command line switch to disable Coherence?
We have a Java app that happens to have the coherence jar in the path.
My application doesn't need it, so I'd like to pass some type of -D variable to the JVM to tell it to ignore coherence, or ...
0
votes
0answers
6 views
What is wrong with table_cache hit rate?
In my.cnf I have:
table_cache = 524288
open_files_limit = 65535
Both are at max allowed value for mysql config. Both are less than max open file limit:
# cat ...
0
votes
0answers
19 views
Should store procedures be cached?
Should store procedures be cached in MySQL? If so, How long it is stay in cache?
In my case, When I call one stored procedure first time, it is giving me results in 1 second, after that it gives me ...
0
votes
0answers
25 views
Req: Typical location of mysql query cache
My MVC framework (CodeIgniter) wants to know where my database (mysql 5.5) writes its query cache. My Ubuntu installation is unexceptional. Would that be /var/lib/mysql/ or further down the chain, ...
0
votes
0answers
42 views
Temporarly disable cache in oracle 11g
I want to disable the caching for my session in oracle 11g to see how long a query takes.
Is this possible or is there a better way for meassuring the time a query takes to run?
