>- 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 -<
