Re: Which delete statement is faster?
- From: "Richard B. Gilbert" <rgilbert88@xxxxxxxxxxx>
- Date: Tue, 16 Oct 2007 16:45:41 -0400
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!
.
- Follow-Ups:
- Re: Which delete statement is faster?
- From: Richard Brodie
- Re: Which delete statement is faster?
- From: Ron Johnson
- Re: Which delete statement is faster?
- From: Jan-Erik Söderholm
- Re: Which delete statement is faster?
- References:
- Which delete statement is faster?
- From: Mike Minor
- Re: Which delete statement is faster?
- From: briggs
- Re: Which delete statement is faster?
- From: Mike Minor
- Which delete statement is faster?
- Prev by Date: Re: Which delete statement is faster?
- Next by Date: Re: CHECKSUM oddity?
- Previous by thread: Re: Which delete statement is faster?
- Next by thread: Re: Which delete statement is faster?
- Index(es):
Relevant Pages
|