RSWUWFML2 performance issue
Paul Bakker
Paul.Bakker at osr.treasury.qld.gov.au
Mon Nov 15 17:15:06 EST 2004
Serge,
An (obvious) suggestion: Perhaps if the emails were buffered, you could=
run
the RSWUWFML2 job regularly during the day?
For example, run the job every hour, but only send the emails at night.=
They are not actually sent until the RSCONN01 job is executed.
(Naturally this won't be acceptable if other processes depend on RSCONN=
01
running regularly...)
cheers
Paul B
=
=20
Serge Boulay =
=20
<Serge.Boulay at n-spr To: SAP-WUG at MITV=
MA.MIT.EDU =20
o.com> cc: =
=20
Sent by: SAP Subject: Re: RSWUWFML=
2 performance issue =20
Workflow =
=20
<Owner-SAP-WUG at MITV =
=20
MA.MIT.EDU> =
=20
=
=20
=
=20
16/11/2004 02:03 =
=20
Please respond to =
=20
"SAP Workflow =
=20
Users' Group" =
=20
=
=20
=
=20
Mark,
We did some testing using the options that you are suggesting but the t=
hing
is that the high volume is on that one task for time sheet approval...
But like I said, it looks like it is the call to the function
SO_NEW_DOCUMENT_ATT_SEND_API1 that makes it slow.
Thanks.
Serge
-----Message d'origine-----
De=A0: SAP Workflow [mailto:Owner-SAP-WUG at MITVMA.MIT.EDU] De la part de=
Griffiths, Mark
Envoy=E9=A0: 15 novembre 2004 10:40
=C0=A0: SAP-WUG at MITVMA.MIT.EDU
Objet=A0: Re: RSWUWFML2 performance issue
The report may take a long term to run the first time you use it.
Couple of ideas:
- Specify a start date in your variant - only check for items in the ne=
ar
past when it is first run
- Use the job suffix function this means that when it runs it only gets=
items since last time it ran.
- Restrict the task selection to only inform users for the tasks you ar=
e
actually using (and need notifying about).
- If you still have very high volumes create different variants based o=
n
tasks, you can then spread the load between a couple of job runs.
Regards,
Mark
-----Original Message-----
From: SAP Workflow [mailto:Owner-SAP-WUG at MITVMA.MIT.EDU] On Behalf Of S=
erge
Boulay
Sent: 15 November 2004 15:29
To: SAP-WUG at MITVMA.MIT.EDU
Subject: RSWUWFML2 performance issue
Hi All,
Does any one had an issue with the performance of RSWUWFML2 ? We had th=
e
system with 17,000 work items in SWWWIHEAD and the program ran for ever=
.
One
of the BASIS seems to think that it is the function
SO_NEW_DOCUMENT_ATT_SEND_API1.
I know that we could run the job more often but the client want to run =
it
once a day... And we are using CATS (time sheets) approval for around
40,000
employees.
Any idea?
Thanks.
Serge Boulay
HR/Payroll & Workflow Consultant
=
More information about the SAP-WUG
mailing list