Solved

List Box Popluation Speed

Posted on 2003-11-03
8
203 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
Comment Utility
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
Comment Utility
>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
Comment Utility
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
 
LVL 35

Expert Comment

by:TimYates
Comment Utility
cache the lists in the servletSession, and rebuild them if the vendor lists change
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 15

Expert Comment

by:jimmack
Comment Utility
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
Comment Utility
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
Comment Utility
0
 
LVL 35

Expert Comment

by:TimYates
Comment Utility
that comes with Tomcat ;-)
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now