Re: Which delete statement is faster?



Mike Minor wrote:
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.....


Thank you for your help....

Mike

200,000+ files in one directory is so ridiculous I can scarcely imagine anyone doing it. You are now finding out just one of the reasons why it's ridiculous.

Can you just INIT the disk and start over? Or back up everything else, INIT and restore?

The last time I had to cope with something like this was eight or nine years ago at McGraw-Hill. Some woman had gone on maternity leave. She had some sort of self resubmitting job that just went right on creating these files.... ISTR that, by the time we discovered it, the directory was well over 2000 blocks in size! It took DAYS to delete all those files!


.



Relevant Pages

  • Re: Which delete statement is faster?
    ... via FTP I realized the magnatude of the ftp process, ... Can you just INIT the disk and start over? ... Give a man a fish, and he eats for a day. ...
    (comp.os.vms)
  • Re: Which delete statement is faster?
    ... 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. ... You are now finding out just one of the reasons why it's ridiculous. ... She had some sort of self resubmitting job that just went right on creating these files.... ...
    (comp.os.vms)
  • Re: Which delete statement is faster?
    ... ftp these files to another server. ... realized the magnatude of the ftp process, ... I noticed a pause of a few seconds after it listed 15 to 20 files that ...
    (comp.os.vms)