Well... first off, there's almost no reason to have a sep of 1. You should write a program to change all of those 1's to 4's.
Second, 11, while not as bad as 1, is still wholly inadequate for all but very small files. THe answer isn't so much a different default as at least a little conscientiousness. If you haven't checked your file sizes in the past quarter, you're neglecting an important maintenance job. Periodic health checks are vital; U2 can run rings around everything else, but not if you have bottlenecks all over the system. Lock table sizing, file sizing, sync settings, select buffer settings, and, of course, programming techniques (I'm astonished at how many times I find files getting opened inside of loops, or how many times I see the same piece of data read a dozen times in a program, for example). > Date: Thu, 11 Mar 2010 16:04:43 -0500 > From: [email protected] > To: [email protected] > Subject: Re: [U2] UniVerse Slow - Fixed > > Dave: > > Thanks for pointing this out. It happened to me because I have a habit of > grabbing the first example out of the UniVerse Reference Manual. I just > marked up my copy. > > Upon seeing this post, perhaps Wally or someone at Rocket will take an action > item to tweak the next release of the UniVerse (and UniData) User Reference > manual.... changing it from say 2 1 1 to 2 11 1. > > --Bill > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of David A Barrett > Sent: Thursday, March 11, 2010 3:02 PM > To: [email protected] > Subject: Re: [U2] UniVerse Slow - Fixed > > Bill, > > >File MESSAGES Type= 2 Modulo= 1 Sep= 1 > > Coming across one of these in a system I'm working on always steams me. It > has to be one of silliest and most easily avoidable time-bombs people can set > in a system. The difference between a modulo 11 and a modulo 1 file on > performance is astronomical, and the disc cost of just making sure that every > file - even one you're absolutely positive will never have more that a couple > of records in - has at least an 11 or a 101 modulo is totally negligible. > > > > Dave Barrett > Project Manager, > Lawyers' Professional Indemnity Company (LAWPRO®) > 250 Yonge Street, Suite 3101, P.O. Box 3 Toronto, Ontario M5B 2L7 > Tel: 416-598-5872 > Fax: 416-599-8341 > > This e-mail may be privileged and/or confidential, and the sender does not > waive any related rights and obligations. Any distribution, use or copying of > this e-mail or the information it contains by other than an intended > recipient is unauthorized. If you received this e-mail in error, please > delete it and advise me (by return e-mail or otherwise) immediately. > > Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce > pas aux droits et obligations qui s'y rapportent. Toute diffusion, > utilisation ou copie de ce message ou des renseignements qu'il contient par > une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si > vous recevez ce courrier électronique par erreur, veuillez le supprimer et > m'en aviser immédiatement, par retour de courrier électronique ou par un > autre moyen. > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _________________________________________________________________ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/201469227/direct/01/ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
