Re: Which delete statement is faster?



In article <13ha3tiakjblj1b@xxxxxxxxxxxxxxxxxx>, "Mike Minor" <mminorhsd@xxxxxxxxxxxxx> writes:
I have a directory with 200000+files, all in the a*.txt;1 range. I need to
ftp these files to another server. After sending 30,000+ files via FTP I
realized the magnatude of the ftp process, and interrupted it. I want to
delete the 30,000+ file already ftp'ed before going back and looking at
continueing the ftp process in a different manner and it just seems to be
taking an extremely long time to perform the delete. I think the hang up is
the re-write of the directory contents back to disk after a few files are
deleted. I did the delete with a /log to watch how long it took to delete a
file. I noticed a pause of a few seconds after it listed 15 to 20 files that
were deleted.....


This is a good reason to get and use DFU, but in the meantime you
make get faster results via backup/delete to the null device.

.



Relevant Pages

  • Re: DD DEST=(MS Windows machine)
    ... The PC is not a "user workstation", it's a server that watches ... the directory the FTP process writes to, ... For IBM-MAIN subscribe / signoff / archive access instructions, ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ...
    (bit.listserv.ibm-main)
  • Re: Writing to a file from an EJB
    ... > the server for an FTP process. ... Here is what I have so far, but I am having trouble... ... This process runs as the web server, more than likely, and problems are often ... the result of 755 perms or the like. ...
    (comp.lang.java.programmer)
  • Re: JINETD Job stuck will not abort?
    ... attempts to get the newly renamed file, so it locks an internal resource ... Change the ftp process to rename the file, pause for a period of time, then ... The file manager has to be given time to do ...
    (comp.sys.hp.mpe)
  • ODBC problems
    ... server. ... We need to do a FTP process. ... conflicts with the ODBC and crashes my MS SQL 7.0 SP4 ...
    (microsoft.public.sqlserver.odbc)
  • Re: Which delete statement is faster?
    ... After sending 30,000+ files via FTP I realized the magnatude of the ftp process, and interrupted it. ... I want to delete the 30,000+ file already ftp'ed before going back and looking at continueing the ftp process in a different manner and it just seems to be taking an extremely long time to perform the delete. ... I think the hang up is the re-write of the directory contents back to disk after a few files are deleted. ... INIT and restore? ...
    (comp.os.vms)