Need experts suggestion please help me out.
I am currently using a system which has nearly 2000 users where 200 simultanious works. system has 2 clusters. The system has huge database. system is completely based on fetching data from db on combination of search criterias on each search nearly 1million records match from which we retrive 2000 and put in session from which we display 200-500 at a time and remaining we keep in session so we are not hitting db if user click second page.
Now because of this heavy load on session system crashed many times. We are in plan to keep data in session tables. db we are using is db2. We are in plan to create session table for each login and load data at first search in session table and use that table again and again. table will be cleared as soon as user logs out.
Is there any better idea as this solving session data problem but not improving speed of an application.
Please advice needed!!:o