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.