could you use a stored procedure and putt the load on the database instead
Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.com - Free CFML hosting for developers www.cfsearch.com - CF search engine On 17 May 2013 06:25, "Tom McNeer" <[email protected]> wrote: > > Sorry for the delay in replying to folks. I appreciate the responses, but > so far none have solved the problem. > > Per Mike, I have placed each individual insert (there will be thousands of > them) in its own transaction. I have not specified a isolation level; if > someone thinks that could make a difference, please let me know. > > I also set incredibly long timeouts (like 2000 minutes) on the database > connection, to test Russ's thought. > > Neither changed anything. The routine stopped inserting records after about > the same amount of time. > > Anyone else have any thoughts on what might be happening, or how I might > diagnose what's happening? > > > > > -- > Thanks, > > Tom > > Tom McNeer > MediumCool > http://www.mediumcool.com > 1735 Johnson Road NE > Atlanta, GA 30306 > 404.589.0560 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
