Solved

List Box Popluation Speed

Posted on 2003-11-03
8
209 Views
Last Modified: 2010-04-01
I have developed a simple application using J2ee arch. For a enquiry screen we need to populate 2 list boxes "Vendor from" and "vendor To" . The list box has 5000 records. due to this list box popluation, the page load takes 15-20 seconds. the customer wants a load time of 1-2 seconds. is there any way of achieving this ? The bean returns the records from the db in milli seconds - it is the popluating the list box in the front end which is the bottleneck.

The Vendor From and To list popluates the same records from a single table which is indexed by Vendor Name

Any ideas is appreciated.
0
Comment
Question by:venkatcg
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 3

Expert Comment

by:applekanna
ID: 9676251
Just a suggestion,

Have a alphabetic list to be chosen before you display the "from" box and then a list to dipslay the "to" box.
Hold all the records in session but display only the chosen alphabets, this way you need to go to the db again.

Even the user would like to scroll thourgh 5000 entries before he chooses one.

0
 
LVL 15

Expert Comment

by:dualsoul
ID: 9676482
>it is the popluating the list box in the front end which is the bottleneck.
what do you mean? you populte list box on the client browser?
if not, than i think you probably do it in your servlet of jsp, or something like this. So then oyu bottleneck not populating, but the time to download so huge page with 5000+ items in listbox.
          Am i right?
if so, try to reduce number of items in listbox, like applekanna suggested.
 if not, plz explain in more details.
0
 
LVL 3

Expert Comment

by:applekanna
ID: 9676490
typo

>Even the user would like to scroll thourgh 5000 entries before he chooses one

Even the user would NOT like to scroll thourgh 5000 entries before he chooses one
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 35

Expert Comment

by:TimYates
ID: 9677527
cache the lists in the servletSession, and rebuild them if the vendor lists change
0
 
LVL 15

Expert Comment

by:jimmack
ID: 9677677
If it is a problem with the bandwidth when transferring the data to a client, consider checking the request (Accept-Encoding) to see if gzip is supported.  If it is, try piping the page through a GZIPOutputStream.  You *may* get the kind of performance increase you're looking for, but in this case there are other factors too (general network latency).

You can get some source code for this from http://www.moreservlets.com.  It's in chapter 9 (listing 9.20).
0
 
LVL 15

Expert Comment

by:jimmack
ID: 9677681
Sorry.  I would have posted the exact link, but the site seems to be unavailable at the moment :-(
0
 
LVL 15

Accepted Solution

by:
jimmack earned 250 total points
ID: 9679309
0
 
LVL 35

Expert Comment

by:TimYates
ID: 9679407
that comes with Tomcat ;-)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Enabling the Skype for Business Meeting Scheduler in Hybrid OWA
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question