How to show 100000 + records in a single web page using Struts/Java/Jsp

Discussion in 'JSP' started by vijaykeshri, Aug 11, 2010.

  1. vijaykeshri

    vijaykeshri New Member

    Joined:
    Jun 6, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    We have created a web application using Struts, Hibernate and Spring. Our clients want to see all 100000+ records on single page. we tried but it's locking/throwing Out of Memory error for Tomcat. Also It's locking the web browser while populating on the screen.

    Can anyone please help me out?
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Your Client want to see them all in one go? Tell him to increase the memory size or ask him to view in pages.
     
  3. vijaykeshri

    vijaykeshri New Member

    Joined:
    Jun 6, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Thanks for reply.

    I have told the same thing to them but they are not agreed.

    Do you know any other way to display records in one go?

    Regards,
    Vijay Keshri
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    It is something like they want to have a BMW car but are not willing to anything but pennies.

    Try fetching only screenful of results and as you detect scrolling using JavaScript Make Ajax Calls to fetch more results. User will see all results and you will do them in parts.
     
  5. parryzen

    parryzen New Member

    Joined:
    Aug 12, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    Home Page:
    http://www.zen-e-solutions.com/
    hi...

    really this very useful questions about the JSP..!!! meet again.
     
  6. vijaykeshri

    vijaykeshri New Member

    Joined:
    Jun 6, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Hi Shabbir,

    I don't think in that case also it will work properly at browser side. I mean it may resolved the Tomcat Server locking Issue but it won't resolve Web Browser locking issue as, We are going to show all 100000+ records on a single web page only.

    Hope, you got what I am trying to say.
     
  7. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    No you are not showing 100000 but only those which are visible to user.

    Try this.

    In any windows platform search for all image files in your hard disk. Now make sure your results are all shown as thumbs.

    Now you will see 1000s of files but as you scroll to any view your see the thumb of those and not the other.

    We learnt this when working for Lexmark that loading all thumbnails actually means lot of resource but for handful of records you do not need to do that.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice