Caching web applications in Java

Question

• What is the better way to cache a Java Web Application using MySQL? to improve performance.
• What are the best techniques to do it?
• It is better to do this at the application level or database level?

I'm new to this, so, sorry if I'm wrong.

Answer 1

Well there are ways to have some performance tips both at database levels and Application levels.

For database levels here are few inputs

1. Query optimization
2. Indexes creation on frequent asked data.

For some ORM layers like hibernate it also provides some sort of mechanism to cache the outputs in primary levels and secondary levels.

For application levels we have many options few of them are

1.EHCache 2. Memcached

JCS

here is a complete list of java based caching frameworks

java-caching-system

and some googling will help you to find many other options for UI layers there are lots of area of improvements like

1. Proper use of HTTP headers
2. Less number of server Hits.
3. Way to load javascripts
4. Way to load CSS files
5. use of CDN severs

Yahoo has very good blog for this.YSLOW from YAHOO.If you are in the early stage of development i will suggest not to go for them as they lead to premature optimization and can lead to may problems.

Answer 2

Why don't you look at below links which could help you.

Article1

Article2

Answer 3

Frameworks exist for this purpose and Ehcache is one of them. Here you can read up on how you can use it:ehcache