PDA

View Full Version : Save Records Row by row - Pl help


ksridhar69
08-27-2002, 01:58 PM
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

Is there any thing with javascript.Pl help me

beetle
08-27-2002, 04:03 PM
Uh, I really don't understand what you are looking for. When you say 'rows', to what are you referring? Table rows? Database rows? And when you say checks, you mean...bank checks?

joh6nn
08-27-2002, 05:36 PM
if i understand you correctly, you've got a form that's filled out, sent to the server, and then returned to the user, about 200 times, and you're looking to reduce the strain on the server, by switching some of the work over to the client side. sadly, i don't think there's anyway to help you. client side javascript doesn't have any way to interact with the server, so it can't be used to save the rows to the server. the only thing that i can think of, that you might be interested in, is remote scripting. it wouldn't cut down on the use of the server, but it might make things easier for the user:

http://developer.apple.com/internet/javascript/iframe.html

hope that helps.