I'm not sure about speed - but I doubt it'll be enough of a difference to
worry about.


If you're comfortable not knowing the outcome you could call CFEXECUTE with
a timeout of "zero" which will launch the process and abandon it.  SoCF will
return quicker. however doing the whole thing in CF allows for much tighter
controls and error checking - I'd rather go reliability than performance
when talking about data integrity.


Jim Davis


  _____  

From: brob [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 2:24 AM
To: CF-Community
Subject: Which is Faster (Dos batch vs coldfusion)?


The database contains rows of data that has information on image files
(source name, name, location).  I want to rename the image names in the
database, as well as rename the files themselves.  I have 2 options

#1.  Have coldfusion rename the image names in the database, then rename the
files (by looping through a QUERY that has the list of image names that had
been changed)  or
#2.  Have coldfusion rename the image names in the database, then write a
Dos batch file that looks something like

ren "1" "1x"
ren "2" "2x"
ren "3" "5435x"
ren "4" "455x"
ren "5" "434x"
ren "6" "343454x"
ren "67" "43443x"

And then use CFEXECUTE to rename those files.

Which would be faster! :)
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to