Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

sql query cache Vs Object level cache  RSS feed

 
ashok ks
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the difference between sql query cache and Object level cache ?
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
An "SQL query cache" propably means either:
a) compiled SQL queries are cached by the JDBC driver, or
b) the results of executed SQL queries are cached by the JDBC driver or by the application's data access layer
In either case, this is all about caching implementation details. Object level caching means that you're caching abstract entities -- objects -- instead of raw data or calculation results.
Please correct me if I've mangled the concepts somehow.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!