sam15
asked on
IMDBcache_produuct.
Is anyone faimilar with IMDB (In memory database or times ten) cache?
I am trying to see why/when would you use this cache with oracle/mysql database or web applications if the database already had cache?
Would it work better than something like memcached for relational databases and why?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Neither compare to memcached which is a different type of product. I have not used memcached but appears to require you to make code changes to your application.
Times Ten is an in-memory product, but remember that at some point the data must be stored to disk drives so that if the computer turns off, the data is not lost.
Oracle does let you pin for more control on cache and therefore "work around" the automatic caching algorithims.
However, knowing your applicaton and database is going to be critical to making a decision on which methods to utilize (alone or together) to find the best performance mix. Clustering can also improve performance and provide redundancy (either web server cluster and/or database cluster)
Times Ten is an in-memory product, but remember that at some point the data must be stored to disk drives so that if the computer turns off, the data is not lost.
Oracle does let you pin for more control on cache and therefore "work around" the automatic caching algorithims.
However, knowing your applicaton and database is going to be critical to making a decision on which methods to utilize (alone or together) to find the best performance mix. Clustering can also improve performance and provide redundancy (either web server cluster and/or database cluster)
ASKER
The times ten database is an HPproduct orignally for database in RAM (no disk involved)l.
But i am thinking how the other cache will work with regular DB on disk. Because of the concurreny controls and database cache itself unless you only cache STATIC data. You can also pin objects in oracle cache so it is not pushed out if desired.