Save all User entered Data
-
I have a data entry entry screen. Here users are entering Checks details in batches. Each batch is having about 200 checks. User wants to save each row after finishing the row. I did by using XMLDom. Which is calling another page? It is perfectly submitting the values to the database? But it is slow and putting lot of load on the front end and increasing heavy network traffic in a 50 people environment. Is there any better way to Insert, Update, delete the rows. I am using asp, Oracle with IE 6.0
-
I have a data entry entry screen. Here users are entering Checks details in batches. Each batch is having about 200 checks. User wants to save each row after finishing the row. I did by using XMLDom. Which is calling another page? It is perfectly submitting the values to the database? But it is slow and putting lot of load on the front end and increasing heavy network traffic in a 50 people environment. Is there any better way to Insert, Update, delete the rows. I am using asp, Oracle with IE 6.0
By saying Front end , do you mean that browser? If so, make sure that the asp page doing database update is returning only S(uccess)/F(ailure) message and then updating the DOM? If that is the case, it shouldn't put any load on front end because the page does not get refreshed. Web-server load (so with N/W load unless it demands upgrade) is ok for 50 users because 50 users can not be 50 concurrent connections, in web environment. cheers vasu