As John stated we use dimensioned arrays but we also equate each attribute which reserves a spot for the piece of data making it tremendously faster updating.
Nicholas M Gettino, Director of Professional Services & Support, EnRoute Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX (678) 393-5389 [email protected] or [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, June 01, 2012 3:00 PM To: [email protected] Subject: U2-Users Digest, Vol 38, Issue 1 Send U2-Users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of U2-Users digest..." Today's Topics: 1. Monthly Multivalue Inserts and Speed (Dave Laansma) 2. Re: Monthly Multivalue Inserts and Speed (Israel, John R.) 3. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko) 4. Re: Monthly Multivalue Inserts and Speed (Dave Davis) 5. Re: Monthly Multivalue Inserts and Speed (Dave Laansma) 6. Re: Monthly Multivalue Inserts and Speed (Wols Lists) 7. Re: Monthly Multivalue Inserts and Speed (Wjhonson) 8. Re: Monthly Multivalue Inserts and Speed (Wjhonson) 9. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko) 10. Re: Monthly Multivalue Inserts and Speed (Dave Laansma) 11. Re: Monthly Multivalue Inserts and Speed (Wjhonson) 12. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko) ---------------------------------------------------------------------- Message: 1 Date: Fri, 1 Jun 2012 10:29:55 -0400 From: "Dave Laansma" <[email protected]> To: <[email protected]> Subject: [U2] Monthly Multivalue Inserts and Speed Message-ID: <071256f97fa0fa498115009ae88175b202cad...@hubmail2.hubbardsupply.com> Content-Type: text/plain; charset="us-ascii" I have a file that is taking a very long time to update, seemingly longer and longer each month. Here is briefly how the attributes are organized, a relatively simple example: Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm 12-03 etc. Attributes 2 through 30 are dependent on attribute 1 and contain a variety of dollar amounts that are accumulated for the respective period in attribute 1. At the end of each month, a new G/L Period is inserted into the multivalued position of attribute 1 as well as each of the respective multivalued 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 12-periods into their respective multivalues in attribute 1 and insert respective <null> multivalues into attributes 2 through 30, thus performing all of the 'inserts' at once, will the processing each month run faster as numbers are simply accumulated into attributes 2 through 30 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 other attributes and the records overall are relatively large, averaging lengths 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 an 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" ------------------------------ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
