I have always preferred dynamic files. In the long run, they are easier to deal with. You should still determine the best block size. Also, if you are going to bulk load it, you should set the min mod so that it does not start splitting right off the bat. You still want the basic size to be accurate if you can determine that up front.
That being said, there is the nasty "blink" error (backward link). The only time I have seen these were in a vendor's proprietary index files, but when we got them, the file was worthless. Fortunately, since they were not "data", we could rebuild these files. John Israel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Tuesday, July 22, 2008 11:36 AM 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
