I'd have to agree with Daniel. CFFILE would have to be faster than CFHTTP, as CFHTTP is adding the web server as an intermediary to the whole process. Both commands will make the operating system read the file, its just that CFFILE will make the CF server do it, and CFHTTP will make the web server do it. You'll also get much faster and more informative feedback from CFFILE if things go wrong and it can't give you the file for whatever reason. Plus, as Daniel says, and my experience has shown as well, CFFILE just works, it works the same way every time, and its reliable. CFHTTP isn't always like that. Admittedly, most of the problems I've had with CFHTTP were when connecting to other web servers, not a web server on the CF server machine. Still, its an extra layer of complexity that I would avoid exposing myself to if possible.
Darren > -----Original Message----- > From: Daniel Morphett [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 05, 2003 9:08 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: CFFILE vs CFHTTP to read file to db > > > I'd steer well clear of cfhttp if I were you: it's crap. > Notoriously slow > and unreliable. > > on the subject, anyone know of a good alternative to it? Like > a cfx tag? > calling a com object instead? > > At 01:34 PM 2/4/2003 +1100, you wrote: > >I am wondering if anyone has any thoughts and opinions on > unsing CFFILE vs > >CFHTTP to read a file and insert the content into a > database. Is one or > >other more reliable, flexible in handling the content. > > > >Currently I use a CFHTTP call to read and loop over the > content of a text > >file to insert it into the database. With CFMX I have had a > few problems > >with the way this works, and since I have not used CFFILE before to > >perform this action, I want to know the communities thoughts on the > >differences. > > > >Thanks > >Mark > > > >--- > >You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > >To unsubscribe send a blank email to > [EMAIL PROTECTED] > > > >MX Downunder AsiaPac DevCon - http://mxdu.com/ > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
