Re: Which delete statement is faster?
- From: koehler@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (Bob Koehler)
- Date: 17 Oct 2007 08:14:10 -0500
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.
.
- 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: Which delete statement is faster?
- Previous by thread: Re: Which delete statement is faster?
- Next by thread: Re: Which delete statement is faster?
- Index(es):
Relevant Pages
|