-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, 10 July 2013 7:54 a.m.
To: 'U2 Users List'
Subject: Re: [U2] File type 30 (dynamic)
Scott
The idea behind a dynamic file is to spread the pain of administratio
Scott
The idea behind a dynamic file is to spread the pain of administration over
the lifetime of an application. So yes, there are overheads and whilst a
well-sized static file will outperform it, a dynamic file in turn will
normally outperform a badly sized static file.
There are some caveats,
ensaje original-
De: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] En nombre de Phil Walker
Enviado el: martes, 09 de julio de 2013 15:51
Para: U2 Users List
Asunto: Re: [U2] File type 30 (dynamic)
I would probably use a distributed file, with a key bas
: Wednesday, 10 July 2013 6:01 a.m.
To: U2 Users List
Subject: Re: [U2] File type 30 (dynamic)
Once you start splitting groups, there's overhead on every write where that
occurs, possibly creating a bottleneck. Dynamic files are good for files with
non-consistent item sizes, and also for files
iginal Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, July 09, 2013 10:10 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] File type 30 (dynamic)
Your mileage may vary, but almost *all* of our files are ty
Once you start splitting groups, there's overhead on every write where that
occurs, possibly creating a bottleneck. Dynamic files are good for files with
non-consistent item sizes, and also for files with oversized items, but that's
not the case here. I'd go with a "wide & shallow" static file f
Your mileage may vary, but almost *all* of our files are type 30's. Some of
them grow and are purged annually as you suggest, for example G/L related
files. *And* we have never resized them. Not ever. Never.
I don't really know why they never need to be resized, some of them have
100,00
Dynamic files work well in most scenarios. We moved most our files to be
DYNAMIC and easy to maintain.
There could be a difference in speed but I don't believe is a game stopper.
RESIZE it when purged to remove unnecessary space.
Cheers!
HP
On Tue, Jul 9, 2013 at 12:15 PM, Scott Zachary wrot