pre-shippers to shippers.

[Chris Kelleher]

Hi peg!
yes. it's been a while, so for reminder sakes, we are on MF/Pro 8.6e, Progress 8.3a04, and NT and UNIX. We have bee having a problem lately where it takes longer and longer to turn pre-shippers into shippers. We use 7.9.2 and 7.9.5. Is there a log file or a work file that needs to be truncated to allow this function to perform faster?
Thanks in advance.

David L. Knowles
Database Administrator
Captive Plastics, Inc
Partners in Plastics Packaging

 

[Chris Kelleher]

Hello David,

Our company PICS has made several performance improvements to
the QAD shipping module for several QAD customers, the problem
lies in that almost all of the shipping functions need to wade through
the abs_mstr and sometimes the absd_det files. By making small
surgical changes to the software itself we have been able to cut
processing times of these functions way down. The data and
the software are generally the culprits here. Deleting and archiving
your shippers will help.


Regards,

Terry Rossi http://mfgpro.pics.com
tpr@pics.com

 

[Chris Kelleher]

Hi Peggers,

Here is the "patch"

At line 215 or so, you are going to find :

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
SHIPLOOP:
for each abs_mstr where abs_shipfrom >= shipfrom
and abs_shipfrom <= shipfrom1
and abs_shipto >= shipto and abs_shipto <= shipto1
and abs_id >= range and abs_id <= range1 no-lock
break by abs_id:
[/code]

Change it for :

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
SHIPLOOP:
--> FOR EACH si_mstr NO-LOCK
--> WHERE si_site >= shifrom
--> AND si_site <= shipfrom1,
--> EACH abs_msr NO-LOCK
--> WHERE abs_shipfrom = si_site
and abs_shipto >= shipto and abs_shipto <= shipto1
and abs_id >= range and abs_id <= range1 no-lock
break by abs_id:
[/code]

It will "fix" the problem.
Meanwhile, if you have any other performance problems, please let me know. I love to fix that kind of problem.

Regards
Real Drouin



--
Real Drouin
Programmer-Analyst
(214) 707-9056
real.drouin@cdid.com
--