>- see footer for list info -< Personally, I would use a DTS as you can perform lots more SQL based logic before the insert - a BCP is kind of a round peg in a round hole and if you try and throw a square in - it will fail - with not comeback. BCP will no doubt be faster as it doesn't have to prep and fire up a DTS etc.. but a DTS is far more robust - and can be controlled via a Stored Procedure and therefore a transaction.
If you had to go for a BCP then I would recommend a BCP into a temp table which you can then perform any error checks on and then you can use a standard transaction to SELECT INTO -this way you can perform have a transaction whereas a cftransaction around a single BCP is pointless = it may lead to potential deadlocks. Ideally any route you take will be controlled via Stored Procedures. N -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Smith Sent: 01 November 2004 09:57 To: Coldfusion Development Subject: Re: [CF-Dev] cftransaction max >- see footer for list info -< you could use a mixture of both... use BCP to import the data to an import tbl, and then run the dts on that. Dunno about the perf benefits though.... Neil, would that make any difference doing it this way??? or is it worth just doing through a straight DTS? ----- Original Message ----- From: Robertson-Ravo, Neil (RX) To: Coldfusion Development Sent: Monday, November 01, 2004 9:46 AM Subject: RE: [CF-Dev] cftransaction max >- see footer for list info -< If you can, you should use DTS -it will be faster and will allow you to do information modification should you need to. The downside of BCP is that it is not written into the transaction log and therefore cannot be rolled back should it fail. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Russ Michaels (Snake) Sent: 30 October 2004 14:26 To: [EMAIL PROTECTED]; 'Coldfusion Development' Subject: RE: [CF-Dev] cftransaction max >- see footer for list info -< Have a look at bulk insert (BCP) instead of doing 200 inserts via CF. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kerry > Sent: 29 October 2004 19:55 > To: Coldfusion Development > Subject: [CF-Dev] cftransaction max > > >- see footer for list info -< > Hi, > I have a mass import to DB script, and use cftransaction to > ensure the whole import succeeds or not at all, the problem > is that jrun.exe and sqlserver.exe max out the server memory > eventually (after about 200 inserts, on a smaller development > box, I assume it would be more like 800 on our production box) > > Has anyone else had troubles with cftransactions of this size? > > Regards, > Adrian > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving > lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to > volunteer your help > >-< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
