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

vijaykeshri's Avatar, Join Date: Jun 2008
Newbie Member
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?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Your Client want to see them all in one go? Tell him to increase the memory size or ask him to view in pages.
vijaykeshri's Avatar, Join Date: Jun 2008
Newbie Member
Quote:
Originally Posted by shabbir View Post
Your Client want to see them all in one go? Tell him to increase the memory size or ask him to view in pages.
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
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.
parryzen's Avatar, Join Date: Aug 2010
Light Poster
hi...

really this very useful questions about the JSP..!!! meet again.
vijaykeshri's Avatar, Join Date: Jun 2008
Newbie Member
Quote:
Originally Posted by shabbir View Post
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.
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.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.