Results 1 to 4 of 4
  1. #1
    rbkasat is offline Member
    Join Date
    Feb 2011
    Location
    MUMBAI India
    Posts
    2
    Rep Power
    0

    Default 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

  2. #2
    Petr's Avatar
    Petr is offline Senior Member
    Join Date
    Jan 2011
    Location
    Russia
    Posts
    618
    Rep Power
    4

    Default

    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
    Skype: petrarsentev
    http://TrackStudio.com

  3. #3
    rbkasat is offline Member
    Join Date
    Feb 2011
    Location
    MUMBAI India
    Posts
    2
    Rep Power
    0

    Default

    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
    Last edited by rbkasat; 02-20-2011 at 04:46 PM. Reason: spell mistake

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,826
    Rep Power
    19

    Default

    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?

Similar Threads

  1. Ask The Experts
    By al_Marshy_1981 in forum New To Java
    Replies: 11
    Last Post: 06-12-2010, 03:55 PM
  2. Organisational EXPERTS!
    By gcampton in forum Forum Lobby
    Replies: 9
    Last Post: 01-06-2010, 12:53 PM
  3. For JSP & JAVA experts -help me please
    By java student in forum JavaServer Pages (JSP) and JSTL
    Replies: 1
    Last Post: 05-26-2008, 11:40 PM
  4. For java experts -help me please
    By java student in forum Advanced Java
    Replies: 1
    Last Post: 05-25-2008, 06:37 AM
  5. Hello Java Experts :)
    By mark-mlt in forum Introductions
    Replies: 2
    Last Post: 04-17-2008, 10:58 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •