Need experts suggestion please help me out.

Hi All,
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

Hi,
What kind of database do you use?
may be you hear about no-sql database. They have many advantage the compare to Relational DBMS.
for example Orient Technologies - Open source solutions built around the Orient DB

Hi petr,
we are at the position that we can not even think about changing db.
there are thousands od etls updating the db. Mainframes is updating the db and so on.......

Any other solution please..

thanks,
Rohit

Storing large amounts of data in a session is generally not a good idea (as you've seen).
What's the performance hit this is supposed to prevent?
Is your round-trip time to the db really that long that you need to store the data?