posted 14 years ago
Hi Friends,
I have a table named MEMBER_DETAILS with fields - LOGIN_ID,PASSWORD,IS_ACTIVE,LAST_LOGIN_TIME.
Due to high traffic and frequent login , I have to proposed a best solution.
Solution 1: Need to interact every time a DB to do a select query with where clause for loginid,password and active.
Solution 2: Load member login details as soon as container gets up and put in to local data structure like. a bean object for member details and a hashmap with login id as Key and bean object as value. As soon as user submits details, it will be validated by local data structure. Off course I need to provide a method which will sync the local data structure with DB when ever a new user registered.
Please suggest which one is good or any other idea.
Thanks