RE: [U2] Badly overflowed Dynamic files

2007-11-29 Thread Kevin Smith
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, November 27, 2007 10:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Badly overflowed Dynamic files Overflowed groups take longer to read, so you want to reduce the number of such groups

RE: [U2] Badly overflowed Dynamic files

2007-11-29 Thread Anthony Youngman
Sent: 29 November 2007 16:10 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Badly overflowed Dynamic files 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

RE: [U2] Badly overflowed Dynamic files

2007-11-27 Thread Anthony Youngman
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