Ansicht
Dokumentation

05150 - Creating indexes to improve performance...

05150 - Creating indexes to improve performance...

CL_GUI_FRONTEND_SERVICES - Frontend Services   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

Creating indexes to improve performance...

That was one of our concerns when we added the index. We have been
monitoring our jobs and the performance looks fine except for a couple of
jobs. One of the job's run time actually doubles, but that is a batch job
that runs once a day. The 30-min report will be run more than 50+ times
every morning.

akl.
Business Solutions Division
United Overseas Bank
Ang.KiamLianZU...
___________________________________________________________________________
When I ask you to take an aspirin, please don't take the whole bottle. -
Harvey Penick

Privileged/Confidential information may be contained in this communication
(which includes any attachment). If you are not an intended recipient, you
must not use, copy, disclose, distribute or retain this communication or any
part of it. Instead, please delete all copies of this communication from
your computer system and notify the sender immediately by reply email.
Thank you.



-----Original Message-----
From: desmond_olwageZg...
[mailto:desmond_olwageZg...]
Sent: Tuesday, February 19, 2002 3:09 PM
To: sap400Zm...
Subject: Creating indexes to improve performance...


Hi, guys.

I have seen several messages regarding the creation of an index to improve
runtime. The example was improving runtime from 30 minutes to 10 seconds by
creating an index.

I approached our ABAP programmers with this info and their reaction was
that they are hesitant to create indexes because of other performance
problems that they might be creating. For example, they could create an
index on the billing table(s) to improve runtime on queries done there, but
that, by doing so, they may increase the runtime on the actual billing
process (system having to update in more places). Is this the case? Can
anyone enlighten me here please?

Thanks.

Des Olwage
Snr. Systems Administrator
Goodyear South Africa
Tel. +27 41 5055441
Cell. +27 82 824 6900




Have a look to our homepage at: http://www.consolut.net
DoNotReply@consolut.eu

Your use of consolut is subject to http://www.consolut.net


Durban Tours - Südafrika Safari

BAL Application Log Documentation   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 3372 Date: 20240221 Time: 203543     sap01-206 ( 2 ms )