Storing user data in Cache/session in Spring based web application

Question

In my project we provide search functionality to user.user can set values in 2 dozen search parameters available.On search we fetch the search result plus store the searchparameters (which were selected by user ) in database(this is causing a serious performance prob),so that next time when the user come to search page his previous search parameter are loaded on page load.

I want to store the search parameter in session or cache (during the entire user session) and when user logs out commit them to database ,instead of committing to database on every search.When user comes to search page DAO checks for value of search parameter first in cache/session then try to fetch from DB. Can anyone suggest any solution for this problem Technology used- Spring 3+ Hibernate 3.6 + Tomcat 6 + EHCache +JSP

So your issue is not caching. Its that you have a bad performance in the search result/store parameters processing. Before saying "we need caching!" fix what's broken. Analyze why that portion is slow, and fix that. Caching isn't a magic bullet. — atrain
– atrain, Commented Dec 23, 2012 at 15:03
calm down my friend.If you understood how the application is working ,i will again explain you the problem. Suppose a user makes back to back 15 searchs, so instead of writing to database 15 times to save the search parameters ,i want to cache the search parameters and write them to database when user logs out (everytime you enter a search parameter into database it overwrites the previously saved search parameters for that particular user) — user1922329
– user1922329, Commented Dec 26, 2012 at 5:24

nickdos · Accepted Answer · 2012-12-22 01:24:37Z

1

Take a look at the Spring EhCache project. It basically caches the return value of a method given a certain (set of) method signature values. There are quite a few caveats, such as the class must implement an interface and method args should be either a primitive, String or a class that is serializable (implements hash code at least).

Getting the ehcache.xml conf file right can be tricky at first as you really do need to read the docs. But once setup, it is pretty straight forward to implement and it is fast.

So you would need to write methods: to populate the search parameters from the UI, a method to return them (cached), another method to store it in the database and then invalidate/clear the cache.

answered Dec 22, 2012 at 1:24

nickdos

8,4145 gold badges32 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1922329 Over a year ago

i want to store user specific data . i dont know how to configure cache to store data that is per user per session specific and not application specific

Collectives™ on Stack Overflow

Storing user data in Cache/session in Spring based web application

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related