Tweaklet that has paid off on some systems: For batch programs that perform sequential SELECTs and sequential or skip-sequential processing. Make the file separation/block size larger than usual and match it to the physical disk transfer unit size of the disk subsystem.
e.g. disk transfer unit size=8k; file blocksize a multiple of 8K It has paid off lots in the past - not sure whether it's still true on modern faster systems with lots of cache tho'. Answers on an email..... Regards JayJay -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: 26 April 2006 19:33 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] File sizing Great replies everyone! Thanks very much. Barry Brevik ------- 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/