Agile Buzz Forum - Caching Database Queries in Java

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Agile Buzz Forum
Caching Database Queries in Java

0 replies on 1 page.

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 0 replies on 1 page

Slava Imeshev

Posts: 114
Nickname: imeshev
Registered: Sep, 2004

Slava Imeshev is a Software Engineer with experience that began when machines were big

Caching Database Queries in Java

Posted: Aug 1, 2008 1:23 PM

This post originated from an RSS feed registered with Agile Buzz by Slava Imeshev.
Original Post: Caching Database Queries in Java Feed Title: Slava on Everything Feed URL: http://jroller.com/imeshev/feed/entries/rss Feed Description: Slava Imeshev's Weblog	Latest Agile Buzz Posts Latest Agile Buzz Posts by Slava Imeshev Latest Posts From Slava on Everything

Caching database queries can reduce and even remove the performance degradation caused by slow database access. I have just finished an article that discusses steps needed to address the performance problem caused by the heavy database queries such as optimizing and caching database queries and provides code examples.

One thing to keep in mind that a plain query cache usually should be bigger than an entity cache because the variability is higher (query text plus parameters). A more advanced approach is a cache of caches. The fist cache indexes query parameter caches using the SQL query text as a key. Here, the queries executed more often have a better chance of avoiding eviction.

Regards,

Slava Imeshev

Read: Caching Database Queries in Java

Previous Topic

Next Topic


	Web Artima.com