Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Phil Walker
- 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

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Brian Leach
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,

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Marc A Hilbert
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

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Phil Walker
: 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

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Rick Nuckolls
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

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Dan Fitzgerald
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

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Wjhonson
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

Re: [U2] File type 30 (dynamic)

2013-07-09 Thread Horacio Pellegrino
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