Problem with performace

[Gregory Kowalik]

Do you guy have any custom created indexes on SWWWIHEAD?
We had similar problems so I ran DB trace to check out the long running selects.
This lead me to creation of 2 indexes, performance than was not a problem.
Also, make sure your database has statistics updated for SWW* tables (we run
them weekly I believe)
 
Greg
 
 
 
 
 
"Roehlen, Peter" <PRoehlen at powercor.com.au> on 04/09/2001 01:00:56 AM
 
Please respond to "SAP Workflow Users' Group" <SAP-WUG at MITVMA.MIT.EDU>
 
To:   SAP-WUG at MITVMA.MIT.EDU
cc:    (bcc: Gregory Kowalik)
Subject:  Re: Problem with performace
 
 
 
Pedro,
 
Not sure that I understood your conditions, but we certainly have the same
symptom here.  Our Production workflow users have to wait several minutes
the very first time they access their workflow inbox (tran. SBWP in version
4.6B) each day.  Afterwards, it loads almost immediately (unless they are
the target of someone's substitution rule.).
 
As this happens only in our production and test systems (test is a copy of
production) and not in our development system I can only assume that this is
related to the number of workitems in our system.  We have currently nearly
a million completed work items in production and test.  I am trying to
arrange to have these archived in the expectation that the performance issue
with SBWP will go away.
 
Can anyone else confirm that the volume of (completed) workitems will affect
access times to SBWP after the buffer has been refreshed?
 
Regards
 
Peter Roehlen.
 
-----Original Message-----
From: Pedro Bezerra [mailto:pedrobezerra at yahoo.com]
Sent: Monday, 9 April 2001 14:33
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Problem with performace
 
 
Hi All workflows gurus,
 
I very preocupied with performace for my workflow
production system. I implemented workflow in 5
production system ( I have the same customizing in the
in production servers ), only one have a performace
problem.
 
Before I transport the workflow customizing, the user
claimed for permormace of the inbox access ( SO01 ).
 
I read all sap notes and not search nothing that help
me. Any workflow gurus had the same problem ? I
appreciated any sugestion for solve this problem.
 
I4m in 40b version using informix database and unix
aix os.
 
thanks in advance.
 
Pedro Bezerra
Workflow Consulting
 
 
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
**********************************************************************
Powercor Australia Ltd. This email and any file attachments are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email in
error please tell us immediately by return email and delete the
document.
**********************************************************************