Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key
The most common problems with conversions to new versions of UV is that the UVCONFIG parameters are not aligned to what they were under the previous release and/or what is appropriate for the new OS and UV version. Where applicable you must also ensure if you are re-hosting (ie., different host) that any applicable kernel changes if using a version UNIX - for the new release are made in accordance with Rocket U2 recommendations and your actual requirements for your application (ie., your UVCONFIG, etc). Check MFILES. Check T30FILES if using dynamic files are set to values equivalent to what you had previous, etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aramaies Sent: Thursday, 5 August 2010 9:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key Good Day, We are in the process of upgrading from Universe 9.6 to 10.3, and we have noticed that the system performance is degraded when we use an I-Type dictionary with subroutine calls, and the item is also an alternate key. It seems that the report run about 4 or 5 times slower. Is there someone else who has encountered similar issues? Any ideas? Best regards, Aramaies Baghdasraian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key
On 05/08/10 00:24, Aramaies wrote: Good Day, We are in the process of upgrading from Universe 9.6 to 10.3, and we have noticed that the system performance is degraded when we use an I-Type dictionary with subroutine calls, and the item is also an alternate key. It seems that the report run about 4 or 5 times slower. Is there someone else who has encountered similar issues? Any ideas? What are you doing in your i-type? Optimisation of your code can make quite a difference. The more data that your i-type needs, that you can feed in via arguments rather than (re)read from file, that's saving reads. If you need to open files, cache them in named common because that USED to be a MAJOR performance killer (much less so nowadays I believe, but still...) Look at your code. The reference to an alternate key makes me suspect you are suffering open/read penalties that you can hopefully optimise away to a large extent. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key
File Opens ARE a major killer -- even today -- we found that just building a 'named common' block used just in a SubRoutine called from dictionaries helped SELECTs and SORTs and LISTs to perform MAGNITUDES better (We're UniData, so YMMV)... We test the 'FILEINFO' for the handle that is carried in NamedCommon, and if FILEINFO for the named common was not filled in, we did the open. Note that you also need to store the 'current path' data as well in the NamedCommon, and check that as well since the NamedCommon persists through 'LOGTOs' -- if you have a LIVE and a TEST account, and you run in LIVE first, the named common will still 'be there' if you simply LOGTO the TEST account - so always test that the account/path used to open a file is the same on 're-use' of the file handle. But I'm here to say - of all things, cache your file handles. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, August 05, 2010 10:23 AM To: U2 Users List Subject: Re: [U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key On 05/08/10 00:24, Aramaies wrote: Good Day, We are in the process of upgrading from Universe 9.6 to 10.3, and we have noticed that the system performance is degraded when we use an I-Type dictionary with subroutine calls, and the item is also an alternate key. It seems that the report run about 4 or 5 times slower. Is there someone else who has encountered similar issues? Any ideas? What are you doing in your i-type? Optimisation of your code can make quite a difference. The more data that your i-type needs, that you can feed in via arguments rather than (re)read from file, that's saving reads. If you need to open files, cache them in named common because that USED to be a MAJOR performance killer (much less so nowadays I believe, but still...) Look at your code. The reference to an alternate key makes me suspect you are suffering open/read penalties that you can hopefully optimise away to a large extent. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe 10.3 - Issues with I-Types when using subroutine calls, and the dictionary items is Alt-key
Good Day, We are in the process of upgrading from Universe 9.6 to 10.3, and we have noticed that the system performance is degraded when we use an I-Type dictionary with subroutine calls, and the item is also an alternate key. It seems that the report run about 4 or 5 times slower. Is there someone else who has encountered similar issues? Any ideas? Best regards, Aramaies Baghdasraian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users