Files that grow at a controlled rate and especially files that could exceed 2G are good candidates for dynamic files. Files that are cleared, or files that have masses of data loaded or removed from them, are not. Work files, for example, can be a horrible use of dynamic files. As was stated earlier, it's crucial that the original block size of the dynamic file be set properly, otherwise the file could split way too often.
On Tue, Jul 22, 2008 at 1:02 PM, Symeon Breen <[EMAIL PROTECTED]> wrote: > We use dynamic files no problem - yes I suppose in certain circumstances > there is an overhead, but it would still be faster than a badly sized > static > file. The conclusion we have is if you are really on top of your file sizes > and administrating things daily there is probably less need for dynamic > files. If however you have hundreds of accounts and files then dynamic > files > are easier to admin and hence probably faster in the long term. > > > > Symeon. > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco > Sent: 22 July 2008 16:36 > To: u2-users@listserver.u2ug.org > Subject: [U2] static/dynamic file(s) opinions wanted! > > hey all, > I have "heard" bad things about using dynamic files versus > hashed/static ones. Can anyone share any thoughts on which is better > (in particular on a system where the files grow at a fairly steady rate). > > I always understood that dynamic files were best on files that did not > change "that much that fast " as the constant need to resize would > outweigh the manual effort of resizing the files manually (or with a > program). > > I am looking for insight (or where to find some insight) on universe and > best file practices (right now I am reading the system description > manual and its helping but lacks insights that I am sure some of the old > pickies on here have) > > so any thoughts/suggestions/ideas/comments are welcomed! > > thanks > > dougc > > ps > > universe 10.1 and aix 5.2 > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.138 / Virus Database: 270.5.3/1565 - Release Date: 7/21/2008 > 6:36 PM > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- -Kevin http://www.PrecisOnline.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
