• Post Reply Bookmark Topic Watch Topic
  • New Topic

Scalability using JSP

 
Nikhil Raj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a scalability question in using JSP. We have a system where in a form customer has to select an existing item. It can be like a drop down list from which user can select. But this item can grow upto say 300,000 records. Obviously we can not load all these records in a drop down box. So we need a search mechanism and narrow down the list. What will be the best solution for such a situation? This item is very widely used in different other forms also. We would like to keep the control in the same form (if possible). Any examples of similar conditions will be highly appreciated. Can we use an applet for search?
Thank you all in advance.
 
Joe Broderick
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why not have your buisness logic in a bean? You could have one JSP page which has some parameters to limit the search, then you could pass those paramaters to a bean which would do the search, generating those limited results, and sending those results to a second JSP page in your drop down list. If the records are comming from a database, there are a bunch of SQL commands you can import.
 
Nikhil Raj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the reply Joe.
I agree with you. But teh only Problem is in the navigation. This is a field in a form (more than one form). Until user navigates to this form (which contains multiple fields like name description, blah.. blah .. and item) we have no way to narrow down the list. The business logic is in a bean and I can use a different jsp for search. But how will I initiate a call to that JSP without leaving the primary form. Oneway can be by a link next to the field, which will open the search window. I am not sure if that is the best way. Looking for any suggestion.
Thanks.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!