I need to develop one JSP that may contain 100+ drop down boxes and 50% of them would have 1000+ records. So definitely it would take long time to load if I load everything at one time and why to load everything, as user is not gonna work on everything at a time. The alternative is to show(not load) 30 drop down boxes and just one value (from DB if one is saved). Now when user clicks on drop down then I will bring all associated values. I will also keep one Next button which will load next 30 combo boxes and so on.
I will try to give insight into that page.
That page would have
BusinessType (Kind of business the company does)
Customer List (List of customers who offer that kind of business ) - Drop Down
Customer Contact (List of contact person for this customer depends of customer selection) - Drop Down again
and some other information again one to one per business type.
So the data/page would look like
Bear wrote:I would back up a step and question whether dropdowns with 100's of entries are usable and come up with alternate means of letting the users choose values.
There might be hundreds of companies who offer Bonding Agent(It's industry term and hard to explain. sorry!) business so that's why customer drop down may contains thousand of entries. But the customer contact would not be more than 10 generally.
And one good news is we are already using Spring MVC + DWR. Spring gives good integration with DWR.