I don't know if changing my the split load from 80% to 70% or if running a "RESIZE [filename] DYNAMIC" command (or both) did the trick, but one of the batches that has been taking up to two hours to complete finished the other night in under 10 minutes.
Thanks a ton. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, November 27, 2007 10:22 AM To: [email protected] Subject: RE: [U2] Badly overflowed Dynamic files Overflowed groups take longer to read, so you want to reduce the number of such groups. Is the size of this file roughly constant, or does it just slowly grow? If it's roughly constant, try setting a MINIMUM.MODULO at around 900,000. It'll hopefully break up a lot of your badly overflowed groups. Or change it away from a dynamic file to a hash-type that better suits your keys. If it grows steadily, try REDUCING your split figure - maybe 70%. Again, that will increase the number of groups, and hopefully reduce your number of overflowed groups. Lastly, I was going to suggest looking at your block size and large records, but I notice you don't have any. Cheers, Wol ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
