|
-- I have a savefile that contains a library with a command that creates a set of logical files for BPCS 6.04 which improves the performance of the programs. This set of logical files was created after investigating the most used programs/files and the acces key used in the programs. I installed this logicals in several companies in Spain .Anyway, the way each customer executes the programs is different ( eg. is not the same pick by line than by order, the key to access file IPP is different), so after installing the logicals in the customers we did a work of investigation to see what was improved and what not. And for the processes we still needed to improve, the way was easy: do a PRTSQLINF for the programs, and check wich SQL's are creating access path or have high estimated query execution time; then create a logical that covers this querys. If anybody wants this library I can send it via e-mail. Is stored in V4R2. Alber López IBS Spain Tfn: + 34 91 383 43 20 Fax : + 34 91 383 50 25 www.ibsesp.com _ -----Mensaje original----- De: Danny Monselise [SMTP:dannym@agis-group.co.il] Enviado el: miércoles, 21 de noviembre de 2001 18:26 Para: bpcs-l@midrange.com Asunto: Re: Poor Response Times ... BPCS INV >From version 6.04 and onwards the package is written enterally in AS/Set+embeded SQL therefore the performance is worse . with subfile you can not go back once you positioned you have to reposition... like i said if you build the right logical ith ecl ech sih and so on the package will start to react like you know from version 4 i have been thru that in December 1998 when i upgraded v4.2 to 6.04 . also think of upgrading the machine by disk size ( source are huge inv500d2 can not be seen thru regular seu because it is more then 32764 lines..) and memory i did that in all 3 sites. good luck Danny dweaver1@mmm.co m To: bpcs-l@midrange.com Sent by: cc: bpcs-l-admin@mi Subject: Re: Poor Response Times ... BPCS INV drange.com 21/11/2001 18:53 Please respond to bpcs-l Al Mac - many thanks for a comprehensive reply. I've got a few things to check now. BEWARE - V6 seems to read ITH in a different way to V4 (we upgraded from this). V4 seems to get a 'screenfull' of data & read more when the user request another page - response-times were OK here with this.... V6 seems to get everything (for that part number) & gives little delay when the user requests another page - just a huge delay initially.... _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l or email: BPCS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. _______________________________________________ This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l or email: BPCS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. -- [ Content of type application/ms-tnef deleted ] -- _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.