| SQL Cache frame work [message #377263] |
Mon, 22 December 2008 03:06  |
mr.rajeshyadav
Messages: 48
Registered: November 2007
|
Member |
|
|
Hi,
I want to develop SQL Cache frame work such that if the query has got same set of conditions the results should be returned from cache instead of from DB and if there is any change in the data base it should get from the data base.
Can any body can suggest some approach to do this.
Thanks in advance,
Raj.
|
|
|
|
|
|
|
|
|
|
| Re: SQL Cache frame work [message #377346 is a reply to message #377320] |
Mon, 22 December 2008 08:15  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
As Franck said there is a built-in result cache in 11g, if you don't want to upgrade to this version then you have to create your own and this has nothing to do with Oracle rdbms.
But in 9.2 JDBC you can use a Cached Row Set, maybe this feature is what you need.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
