Yes SQL server has a "bulk insert" facility. From a text file. We had an app that was doing same as your doing, is was a VB app tho not a webapp, but even this was cut down to a 10th of the time using bulk insert.
Just lookup "bulk insert" in your books online and should tell you what u need. Russ > -----Original Message----- > From: Paul Johnston [mailto:[EMAIL PROTECTED] > Sent: 12 January 2004 17:38 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Bulk Insert Into SQL Server DB > > > Ok. I am building a system using CF to insert a large amount > of data into a database (SQL Server 2k). > > Problem is that it's large amounts of data on a regular basis > (think of it as an info gathering tool). The tool basically > recieves a large regular amount of data, and needs to > re-format and deposit into the database. > > Problem is that it takes up resources in CF that are quite > unnecessary (I think). Is there anyway I can dump all the > data into a text format of some sort and do a bulk insert of > that data? > > Paul > -------------------------- > Paul Johnston > PJ Net Solutions Ltd > E: [EMAIL PROTECTED] > M: +44 7866 573013 > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
