Allen Egerton wrote:
As I understand it, Dynamic files split single groups as you add records
to the specific group. So, if you add a large number of records to a
file that's properly sized, it will (potentially) split multiple times
as you go along.
If I know in advance that I'm adding a
2. Use resize if you can get exclusive use of the file. (I don't
think CONCURRENT works with dynamic files. but I'm wary with
static too.)
RESIZE will allow you to set the minimum modulus, but maybe not using
the syntax as documented. And syntax differs according to acct
flavour and OS (and
Subject: Re: [U2] UV 10.1.22; Dynamic File question
Allen Egerton wrote:
The situation is that I'm potentially adding a million records to a
dynamic file. That's not hypothetical, it's a real life scenario. And
I don't want to wait while the file splits multiple times over the
course of the add
Dan Fitzgerald wrote:
... and at this point I'd be thinking static file. Distributed, if
necessary.
snip
Ayup. But I'll quote myself from an earlier post:
I've got some slightly unusual circumstances and client induced
constraints that I'm working under.
--
Allen Egerton
aegerton at pobox
You can set a min modulo on a dynamic file when you build it (or rebuild it).
In theory, this will reduce the splitting until you hit that min modulo. This
does of course assume your files hash fairly evenly, etc, etc.
However, if you purge the file, it will still take up all that space based
Hi Allen,
If I know in advance that I'm adding a large number of records
to a file, is there any way to force the file to grow in advance?
You could do this with the MINIMUM.MODULUS parameter but the whole point of
dynamic files is that they do their own tuning. Although a dynamic file is
You can create the dynamic file with the desired size.
From HELP CREATE.FILE:
MINIMUM.MODULUS n
This value is also the initial value of the modulo (sic) of the dynamic
file.
Best regards,
Henry
Henry P. Unger
Hitech Systems, Inc.
http://www.hitech.com
-Original Message-
From:
My understanding is the when a dynamic file's *total* size exceeds the
SPLIT.LOAD threshold, a group (almost certainly not the group you are
writing to or just wrote to) will be split. The group(s) chosen to be split
are controlled by some secret algorithm, but I don't believe that the
largest
While CREATE.FILE . . . MINIMUM.MODULUS does indeed reserver room in the
primary DATA30 file, it does NOT reserve any room in OVER30 where
large records ( group overflow) lives.
But you can leverage that comment about purges: At some non-primetime
convenient to you, create a bunch of dummy
Martin Phillips wrote:
Hi Allen,
If I know in advance that I'm adding a large number of records
to a file, is there any way to force the file to grow in advance?
You could do this with the MINIMUM.MODULUS parameter but the whole point
of dynamic files is that they do their own tuning.
@listserver.u2ug.org
Subject: Re: [U2] UV 10.1.22; Dynamic File question
My understanding is the when a dynamic file's *total* size exceeds the
SPLIT.LOAD threshold, a group (almost certainly not the group you are
writing to or just wrote to) will be split. The group(s) chosen to be split
are controlled by some
-us...@listserver.u2ug.org] On Behalf Of Allen Egerton
Sent: Friday, 24 April 2009 07:39
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV 10.1.22; Dynamic File question
[snip]
The situation is that I'm potentially adding a million
records to a dynamic file. That's not hypothetical, it's
Allen Egerton wrote:
The situation is that I'm potentially adding a million records to a
dynamic file. That's not hypothetical, it's a real life scenario. And
I don't want to wait while the file splits multiple times over the
course of the add. I don't have that large a window. I want to
13 matches
Mail list logo