The funniest or most gruesome file tuning that I've seen was a few years ago, at a site that I won't name, who had a master file with a modulo of exactly 100 and where 99% of the ids were numbers ending in 00.
Definitely not tuned by "FAST" - - maybe they'd used "SLOW"? Answering Mark's question, "did it really matter to be prime?" . . . No, but if your group distribution is extremely lumpy or spiky, then, as Henry Eggers once said, your file is walking around with a sign taped to the back of its shirt, saying, "Hit Me!". -- CONFIDENTIALITY: The information transmitted is intended only for the person or entity to which it is addressed and may contain material that is confidential, privileged and exempt from disclosure under applicable law. Any review, re-transmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material in a secure receptacle or by shredding the document (s). -- -----Mark Johnson wrote: ----- To: <u2-users@listserver.u2ug.org> From: "Mark Johnson" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] Date: 08/30/2005 09:16AM Subject: [U2] Prime number file modulos A little non-U2 but I'm sure still answerable by many experienced MV persons. One client (AP-Pro, Native) reported to me a bunch of GFE's. Upon further investigation, all of the involved data files had non-prime modulos. This begs the question. Did it really matter to be prime. I understand the concept of prime numbers and the many forms of hashing so let's not deviate into a hashing thread debate. I'm just interested to learn first-hand observations on native systems with non-prime file modulos. Thanks in advance. Mark Johnson ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/