The 3K size is only relevant when you are acting on the item in the runtime engine. When you write it back out, the relevant information is how many of its *siblings* does it have to reshuffle about That's why the number of bytes per group is important, because each write reshuffles the group.
At least it should. Perhaps UD has some trick where it doesn't need to do this for *out of group* large items, or perhaps it doesn't even have that concept in the first place, I'm not sure. -----Original Message----- From: Dave Laansma <dlaan...@hubbardsupply.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Fri, Jun 1, 2012 10:09 am Subject: Re: [U2] Monthly Multivalue Inserts and Speed FILE.STAT results: MOD OV HTY ITEMS BYTES MNI/G MXI/G MNB/I MXB/I 7801 0 64 731825 2197829057 0 27 19 14300 ----- ------- ------- 7801 731825 2197829057 Sincerely, avid Laansma T Manager ubbard Supply Co. irect: 810-342-7143 ffice: 810-234-8681 ax: 810-234-6142 ww.hubbardsupply.com Delivering Products, Services and Innovative Solutions" ----Original Message----- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. asylenko ent: Friday, June 01, 2012 12:07 PM o: U2 Users List ubject: Re: [U2] Monthly Multivalue Inserts and Speed What's the record count and total byte count? ... david ... David L. Wasylenko resident, Pick Professionals, Inc ) 314 558 1482 l...@pickpro.com ----Original Message----- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma ent: Friday, June 01, 2012 9:41 AM o: U2 Users List ubject: Re: [U2] Monthly Multivalue Inserts and Speed Results of the ANALYZE.FILE: Dynamic File name = WHSE.STAT umber of groups in file (modulo) = 67801 inimum groups of file = 67801 ash type = 0, blocksize = 16384 plit load = 10, Merge load = 5 plit/Merge type = KEYONLY Sincerely, avid Laansma T Manager ubbard Supply Co. irect: 810-342-7143 ffice: 810-234-8681 ax: 810-234-6142 ww.hubbardsupply.com Delivering Products, Services and Innovative Solutions" -----Original Message----- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. asylenko ent: Friday, June 01, 2012 10:32 AM o: U2 Users List ubject: Re: [U2] Monthly Multivalue Inserts and Speed 3k isn't large. 1 thing to look at is file size. Change the file-type to dynamic. It will not give the best performance ompared to monitoring file size of a static file type, but over the ong-term, avoids sizing issues that are the #1 reason for bad erformance. Can you perform an "ANALYZE.FILE {filename}" and post the result? ... david ... David L. Wasylenko resident, Pick Professionals, Inc ) 314 558 1482 l...@pickpro.com ----Original Message----- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma ent: Friday, June 01, 2012 9:30 AM o: U2-Users@listserver.u2ug.org ubject: [U2] Monthly Multivalue Inserts and Speed I have a file that is taking a very long time to update, seemingly onger and longer each month. Here is briefly how the attributes are rganized, a relatively simple example: Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm 2-03 etc. Attributes 2 through 30 are dependent on attribute 1 and contain a ariety of dollar amounts that are accumulated for the respective period n attribute 1. At the end of each month, a new G/L Period is inserted into the ultivalued position of attribute 1 as well as each of the respective ultivalued positions in attributes 2 through 30. Nothing complicated. My question is this and is aimed largely at the technicians at Rocket .. If, at the beginning of the year, I were to insert each of the 2-periods into their respective multivalues in attribute 1 and insert espective <null> multivalues into attributes 2 through 30, thus erforming all of the 'inserts' at once, will the processing each month un faster as numbers are simply accumulated into attributes 2 through 0 and no inserting of new multivalues will have to be performed? A couple nuggets of information: This is only an example. In the actual file, these records contain many ther attributes and the records overall are relatively large, averaging engths of about 3,000 according to FILE.STAT These are not my files so reorganizing them is not an option. The heart of this question is, as a (numeric) number is accumulated in n attribute, multivalue or subvalue, what causes the record to stretch' in length, thus presumably impacting performance? I would like to think that numeric information is stored in a more compact' method than strings, thus using less space within the database .. but what I 'like' and what 'is' are often quite different. Thanks! Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com <http://www.hubbardsupply.com> "Delivering Products, Services and Innovative Solutions" _______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
