Hey Doug, Thanks for your confirmation of my understanding Wally's adeptness in Unidata. I always wait anxiously for his replies to these threads.
I believe the *100 simply gets the percentage to a whole number so the INT() works. I am indeed going to go to the 8k block size to reduce the % of 'wasted' space to < 2%. That just seems like a reasonable without going all the way to 16k blocks. I'm also going to increase the modulo by 20% from the number of records so it will have a little extra room to grow over the next few months. I'll probably configure the SPLIT for 10% and MERGE for 5% unless someone discourages me before noon tomorrow. That's when I'm pulling the trigger on this resize. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com "Delivering Products, Services and Innovative Solutions" -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Doug Averch Sent: Friday, June 29, 2012 4:17 PM To: U2 Users List Subject: Re: [U2] Really trying to understand dynamic file sizing Hi Dave and others: Having worked for Wally many years ago at Unidata, his knowledge is unparalleled about Unidata. So given that I've been doing this for a number of years, I'm not sure where the 100 number is coming. The other numbers I have reams of paper, CD's, and thumb drives backing up all of the other numbers. I have tested many a file with different blocks sizes with the same data either adding or subtracting records. I found the split and merge to not happen when I would expect it to. If you put more keys into a smaller modulo the percentage will change because you are using KEYONLY. Your record size is quite large so that is why going to a 2K block size will make things worse. I would recommend going to a 8K block size leaving the current modulo since you a near 100% overflow. You can try it on a temporary file and either tell me I'm wrong or I'm right. Regards, Doug www.u2logic.com/tools.html " _______________________________________________ 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
