Re: Which delete statement is faster?
- From: Hein RMS van den Heuvel <heinvandenheuvel@xxxxxxxxx>
- Date: Tue, 16 Oct 2007 19:58:14 -0000
On Oct 16, 3:23 pm, "Mike Minor" <mminor...@xxxxxxxxxxxxx> 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
So those files are 'early on' in the directory.
'In place' renaming to ;2 for easy exclusion with FTP is not a bad
thought!
What OpenVMS version?
The problem is somewhat similar to one discussed in:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1165943
You may want to check out my rename suggestion there.
It does a double rename to allow the system to allways take from and
add to the end.
This avoids the expensive 1-block shuflef up to make room when
inserting an 'early' file and the
equally expensive shuffle down when the last entry from vbn 1 is
removed.
You may want to adjust it to pre-establish 5K - 25K - chunks of file
to be dealt with.
Cheers,
Hein.
.
- Follow-Ups:
- Re: Which delete statement is faster?
- From: Hein RMS van den Heuvel
- 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: login from mailbox?
- Previous by thread: Re: Which delete statement is faster?
- Next by thread: Re: Which delete statement is faster?
- Index(es):
Relevant Pages
|