Very poor and inconsistent Inbox performance

[Dart, Jocelyn]

Watch out for two other things:

1. Some user settings have known performance costs such as the setting
to show work items in user's own language - which means every work item
has to be translated as it is rendered in the inbox. 

2. It could be caused by bad coding behind your object - e.g. if you
have a virtual attribute used in your work item long text with
performance-costly coding behind it then because the work item long text
is rendered in the inbox preview this in itself can cause the bad
performance.  I had this once at a customer (attribute code = read
entire year's data very badly to calculate single figure) - not fun to
find!    Turning on runtime analysis and other trace tools may help to
identify if there is an excessive amount of processing happening against
any one table or program which may help narrow it down. 


Regards,
Jocelyn Dart
Senior Consultant
SAP Australia Pty Ltd.
Level 1/168 Walker St.
North Sydney 
NSW, 2060
Australia
T   +61 412 390 267
M   + 61 412 390 267
E   jocelyn.dart at sap.com
http://www.sap.com

The information contained in or attached to this electronic transmission
is confidential and may be legally privileged. It is intended only for
the person or entity to which it is addressed. If you are not the
intended recipient, you are hereby notified that any distribution,
copying, review, retransmission, dissemination or other use of this
electronic transmission or the information contained in it is strictly
prohibited. If you have received this electronic transmission in error,
please immediately contact the sender to arrange for the return of the
original documents. 
Electronic transmission cannot be guaranteed to be secure and
accordingly, the sender does not accept liability for any such data
corruption, interception, unauthorized amendment, viruses, delays or the
consequences thereof.
Any views expressed in this electronic transmission are those of the
individual sender, except where the message states otherwise and the
sender is authorized to state them to be the views of SAP AG or any of
its subsidiaries. SAP AG, its subsidiaries, and their directors,
officers and employees make no representation nor accept any liability
for the accuracy or completeness of the views or information contained
herein. Please be aware that the furnishing of any pricing information/
business proposal herein is indicative only, is subject to change and
shall not be construed as an offer or as constituting a binding
agreement on the part of SAP AG or any of its subsidiaries to enter into
any relationship, unless otherwise expressly stated. 


-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Rick Sample
Sent: Wednesday, 09 August 2006 10:53 PM
To: sap-wug at mit.edu
Subject: Re: Very poor and inconsistent Inbox performance

Partha,
We are on 4..6c and when we get near 1000+ WIs (or Documents) things
start slowing 
down when users spin up the inbox. 

50 - 150 WIs is nothing! I would review what Mike stated. Anything 
dynamic when loading SWBP will slow it down. 

Also, how many Documents are in the inboxs? Of what type? How large?
Large attachments?
> I have cleaned the workflow environment of all extraneous and...
Any inbox reorgs? SO30 / 31, etc. lately? 
A boat load of Documents in users inboxes have also caused us some
delays.

Rick

>>> asap at workflowconnections.com 8/9/2006 1:47 >>>
Hi Partha,

Ramki's suggestion is a good one, if that is not the case it may also
be
the work items that are causeing it. Are the long and the short users
looking at the same tasks?

If not, try to isolate the task that's slowing things down. An overly
complex virtual attribute used in the task description can cause
chaos.

In terms of table size, even 500,000 is tiny and completed work items
shouldn't slow things down.

Cheers,
Mike


> Hi Everyone,
>
> Got a weird one that I have not run into before.  We are on 6.20
Basis
> with 4.7 Enterprise (patch level 55).
>
> Different users are getting wildly different performances in trying
to
> enter the t-code SBWP.  Some get in with 1 - 2 minutes and others it
> takes over 30 minutes.
>
> Each user has between 50 and 150 workitems.
>
> We are using the the standard layouts and no one is using dynamic
> columns (there are dynamic columns available but no one is using
them
> yet).
>
> I have cleaned the workflow environment of all extraneous and
> completed workflows (only 9000 total remaining -- down from
500,000).
>
> Anyone else experience this type of poor and inconsistent
performance?
>
> Thanks,
> Partha
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu 
> http://mailman.mit.edu/mailman/listinfo/sap-wug 
>


_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu 
http://mailman.mit.edu/mailman/listinfo/sap-wug 

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug