Package up the information necessary in xml and send that to the server at one time. Let the server build and execute the queries.
Tracy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of bsdensmore Sent: Thursday, January 04, 2007 12:44 PM To: [email protected] Subject: [flexcoders] Database insert with 100's of rows The application I'm currently working on uses a datagrid that can sometimes contain 100's of rows. All of these rows need to be inserted or updated in our database when editing. I'm finding that if there is a large amount of data, doing the inserts can take forever and Flex eventually times out. Looping over each row and calling the function over each iteration seems to take a while when there are a lot of rows. I'm using Remoting with ColdFusion. Is there a better way to handle this? Thanks, Ben
