In this particular case I had 30k + records. I only instantiated the record object once and then continually reinitialized and populated the object with new data each time through the loop (which, as far as I know, does not rebuild the object each time).
I let the page run overnight one night and it only managed to get through about 14k records. I then removed any calls to reactor and used my own in-line SQL insert statements. When I reran the import, it went through all 30k+ records in less than 45 minutes. I actually have to do the import twice...once now with a snapshot of the data while building the application and once again when we get ready to actually make the cut-over from the old system to this new one as currently there are data manipulations going on daily on the old system. I was just curious if there was a mechanism in Reactor that I didn't know about to insert multiple records into the database at once but it appears as though it's still best to roll your own SQL in those situations. Thanks Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Chiverton Sent: Thursday, February 22, 2007 9:10 AM To: [email protected] Subject: Re: [Reactor for CF] Insert multiple records question On Thursday 22 Feb 2007, Dan Skaggs wrote: > but it was incredibly slow. You only have to do it once though. -- Tom Chiverton Helping to proactively create second-generation web-readiness -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
