× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: Poor Performance in INV900
  • From: "Nick Smith" <nick.smith@xxxxxxxxxxxx>
  • Date: Wed, 18 Nov 1998 08:15:00 -0800

How exactly are you able to do this? Can you provide more details on the
process?






BPCS-L@midrange.com on 11/18/98 06:34:00 AM
To:     BPCS-L@midrange.com
cc:      (bcc: Nick Smith/Powerfood)

Subject:         RE: Poor Performance in INV900

From: BPCS-L@midrange.com
Date: Wed, Nov 18, 1998 6:34 AM
Subject: RE: Poor Performance in INV900
To: 'BPCS-L@midrange.com'

One thing I have been experimenting on to improve performance is to set the
all the logical files except the one's being used by INV900 to REBLD(*YES)
at the beginning of the procedure and at the end of the procedure setting
them back to REBLD(*IMMED).  That way it does not have to update the indexes
of all the logical files over the ITH file while it runs.

Another thing that can be done is move the ITH purge to a separate program
that can run when time is available - like the next weekend.

Best Regards,
Roger Wolf

> -----Original Message-----
> From: Michael Ozanne [SMTP:mozanne@midori-no-ryu.demon.co.uk]
> Sent: Tuesday, November 17, 1998 6:47 PM
> To:   BPCS-L@midrange.com
> Subject:      Re: Poor Performance in INV900
> 
> In message <912f9aa8.3651ef07@aol.com>, Devinbowen@aol.com writes
> >Does anyone know if INV900 is stricken with the same inefficient SQL
> >statement(s) as ACR900 (earlier messages)?  We are in prototyping and are
> >experiencing the same kind of poor performance in the inventory month-end
> >close as was described for ACR900.  We're on v6.0.02 (HP Oracle).  Any
> >specifics anyone can give on a fix would be appreciated.
> 
> INV900 has always been a dog, ITH is usually the biggest file in the
> database, INV900 purges old records from ITH then re-indexes it and all
> its 30 plus logical views.
> 
> -- 
> Michael Ozanne (Also ozannem@pacific.co.uk)
> +---
> | This is the BPCS Users Mailing List!
> | To submit a new message, send your mail to BPCS-L@midrange.com.
> | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: dasmussen@aol.com
> +---

----------
Received: from KITTEN.MCS.com by pearl.fabrik.com
        with ESMTP (Fabrik F07.3-000) 
        id SINN.5009145@pearl.fabrik.com ; Wed, 18 Nov 1998 07:40:27 -0800
Received: from uucphost.mcs.net (Uucp1.mcs.net [192.160.127.93]) by
Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id JAA06480; Wed, 18 Nov 1998 09:39:41
-0600 (CST)
Received: (from uucp@localhost)
        by uucphost.mcs.net (8.8.8/8.8.8) id JAA29677;
        Wed, 18 Nov 1998 09:39:40 -0600 (CST)
Received: (from majordom@localhost)
        by midrange.com (8.9.1/8.9.1) id JAA17685
        for bpcs-l-outgoing; Wed, 18 Nov 1998 09:16:55 -0600
Received: (from uucp@localhost)
        by midrange.com (8.9.1/8.9.1) with UUCP id JAA17324
        for BPCS-L@midrange.com; Wed, 18 Nov 1998 09:02:53 -0600
Received: from dresden.garmin.com (dresden.garmin.com [208.196.167.131])
        by uucphost.mcs.net (8.8.8/8.8.8) with ESMTP id IAA24034
        for <BPCS-L@midrange.com>; Wed, 18 Nov 1998 08:34:02 -0600 (CST)
Received: from dresden.garmin.com (root@localhost)
        by dresden.garmin.com with ESMTP id IAA28449
        for <BPCS-L@midrange.com>; Wed, 18 Nov 1998 08:27:12 -0600 (CST)
Received: from dallas.garmin.com ([10.1.0.44])
        by dresden.garmin.com with ESMTP id IAA28432
        for <BPCS-L@midrange.com>; Wed, 18 Nov 1998 08:26:52 -0600 (CST)
Received: by DALLAS with Internet Mail Service (5.5.2232.9)
        id <W83DX1SD>; Wed, 18 Nov 1998 08:34:04 -0600
Message-ID: <71471DFD03A7D11191E000600852EC6FD4313A@DALLAS>
From: "Wolf, Roger" <Roger.Wolf@garmin.com>
To: "'BPCS-L@midrange.com'" <BPCS-L@midrange.com>
Subject: RE: Poor Performance in INV900
Date: Wed, 18 Nov 1998 08:34:00 -0600
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2232.9)
Content-Type: multipart/alternative;
        boundary="----_=_NextPart_001_01BE1300.7D62B060"
Sender: owner-bpcs-l@midrange.com
Precedence: bulk
Reply-To: BPCS-L@midrange.com
X-List-Name: BPCS Users Mailing List (BPCS-L@midrange.com)

----------
Content-Type: text/plain

----------
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

----------


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2232.0">
<TITLE>RE: Poor Performance in INV900</TITLE>
</HEAD>
<BODY>
<BR>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">One thing I have been 
experimenting on to improve performance is to set the all the logical files 
except the one's being used by INV900 to REBLD(*YES) at the beginning of the 
procedure and at the end of the procedure setting them back to 
REBLD(*IMMED).&nbsp; That way it does not have to update the indexes of all the 
logical files over the ITH file while it runs.</FONT></P>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Another thing that can be done is 
move the ITH purge to a separate program that can run when time is available - 
like the next weekend.</FONT></P>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Best Regards,</FONT>
<BR><B><I><FONT COLOR="#000080" SIZE=7 FACE="Brush Script MT">Roger 
Wolf</FONT></I></B><I></I>
</P>
<UL>
<P><FONT SIZE=1 FACE="Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Arial">From:&nbsp;&nbsp;</FONT></B> <FONT SIZE=1 
FACE="Arial">Michael Ozanne [SMTP:mozanne@midori-no-ryu.demon.co.uk]</FONT>
<BR><B><FONT SIZE=1 FACE="Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT SIZE=1 
FACE="Arial">Tuesday, November 17, 1998 6:47 PM</FONT>
<BR><B><FONT SIZE=1 FACE="Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT 
SIZE=1 FACE="Arial">BPCS-L@midrange.com</FONT>
<BR><B><FONT SIZE=1 
FACE="Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> 
<FONT SIZE=1 FACE="Arial">Re: Poor Performance in INV900</FONT>
</P>

<P><FONT COLOR="#000000" SIZE=2 FACE="Arial">In message 
&lt;912f9aa8.3651ef07@aol.com&gt;, Devinbowen@aol.com writes</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">&gt;Does anyone know if INV900 is 
stricken with the same inefficient SQL</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">&gt;statement(s) as ACR900 
(earlier messages)?&nbsp; We are in prototyping and are</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">&gt;experiencing the same kind of 
poor performance in the inventory month-end</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">&gt;close as was described for 
ACR900.&nbsp; We're on v6.0.02 (HP Oracle).&nbsp; Any</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">&gt;specifics anyone can give on 
a fix would be appreciated.</FONT>
</P>

<P><FONT COLOR="#000000" SIZE=2 FACE="Arial">INV900 has always been a dog, ITH 
is usually the biggest file in the</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">database, INV900 purges old 
records from ITH then re-indexes it and all</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">its 30 plus logical views.</FONT>
</P>

<P><FONT COLOR="#000000" SIZE=2 FACE="Arial">-- </FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">Michael Ozanne (Also 
ozannem@pacific.co.uk)</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">+---</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| This is the BPCS Users Mailing 
List!</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| To submit a new message, send 
your mail to BPCS-L@midrange.com.</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| To subscribe to this list send 
email to BPCS-L-SUB@midrange.com.</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| To unsubscribe from this list 
send email to BPCS-L-UNSUB@midrange.com.</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">| Questions should be directed to 
the list owner: dasmussen@aol.com</FONT>
<BR><FONT COLOR="#000000" SIZE=2 FACE="Arial">+---</FONT>
</P>
</UL>
</BODY>
</HTML>

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.