Rank: ? (46)
Member #: 24599

Hi All,

I want to take some associate details online....Each time, the user can enter the details of 10 associates(i.e) (10 rows will be displayed in the form for him to enter) and clicks on 'next' to go to enter other associatesand so on...(noramally there will be more than 50 or 60 or even more associates which cannot be entered at a stretch on a single page).and each entry page should have 'next' and 'prev' options so he can move to any page for refering the details....He must also have a save option in each page so that data wont be expired if session expires in btw. Finally when he clicks on submit....all the data should be submitted...

In addition to the above normal flow...each time, he moves from a page..the data he entered should be compared with the already existing data(to check if few date fields fall between some existing dates in the database ) and should tell the user that he entered invalid data and must enable him to change it before going to next page.

In a nut shell....I want to take associate details, validate them with the data existing in database(each row has to be compared with all existing rows in database) and them store them...If there is any invalid data...must enable the user to change the wrong entered rows....To avoid scrolling in single page, he must have next and prev page options while entering the data

I want this functionality to be done using JSPs and Mysql without effecting the performance. I tried doing this, but I am getting performance issues becos...
1) There is too much of data that is to be taken .
2)Comparisions with the database that are to be done after submitting.If the user constantly fluctuates with next and prev buttons...each time, all the validations must be done,resulting in unnecessary overloading.

Is there any efficient way of solving this??? Please donate your ideas....

Rank: ? (4)
Member #: 26138

It's not a good idea to store too large amout of data in the session.

Y not just let them enter 10 associate at once and you can save a lot of server resources and improve the performance. when they want to check their data, just let them list the data that they have just entered. if they need to modify anything let them modify one by one. isn't tat more easier.