I have not used dynamic files on UV, but on UD we have extensive experience
with them on very large files.
I never recommend UD dynamic files as a way around file-sizing because on
the very large files, on UD, the split pointer is inevitably somewhere
distant from the group being written, so you go into overflow on the group
being written, and then have 2 or more extra writes as another group is
split. With high volumes on transactions on very large files, this is a
significant impact, and it still results in a file needing resizing.
I always recommend FAST from Fitzgerald & Long for our customers - it makes
resizing huge numbers of files very easy. I find we get much better
performance on systems with properly-sized files, static where possible.
And no, this is not an AD, I don't work for Fitzgerald & Long!
Susan Lynch
F. W. Davison & Company, Inc.
----- Original Message -----
From: "Symeon Breen" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: 07/22/2008 3:02 PM
Subject: RE: [U2] static/dynamic file(s) opinions wanted!
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: [email protected]
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
[email protected]
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
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
