topic Re: what is optimization? in Application Development and Automation Discussions

what is optimization?

Former Member — Mon, 15 Sep 2008 12:09:23 GMT

Hi gurus,

Can anybody tell me what is optimization? How can we do the same ? what are main steps involve init?

Thanks in advance.

Re: what is optimization?

ThomasZloch — Mon, 15 Sep 2008 12:32:37 GMT

[http://en.wikipedia.org/wiki/Optimization_(computer_science)]

Re: what is optimization?

Former Member — Mon, 15 Sep 2008 12:33:45 GMT

Usually when you talk about optimization you try to improve the performance of your report.

First you should do a runtime analysis to find out where the most time is spent in your report e.g. Database Access, form routines, etc.

Once you identified the hot spots you take a look at them and try to make coding adjustments to improve the performance.

e.g. for DB make sure that a primary key is used for access or at least an index, don't combine buffered and unbuffered tables in a join

Select data into an internal table en block and read from that table later rather than doing select singles every time.

There is lots of information out there regarding performance improvement. I hope I could point you in the right direction.

Regards,

Michael

Re: what is optimization?

Former Member — Mon, 15 Sep 2008 12:35:27 GMT

Hi,

Check thi slink for performance optimization related links-

/thread/1010274 [original link is broken]

Re: what is optimization?

Former Member — Mon, 15 Sep 2008 15:27:35 GMT

Hi Pravin,

Please use the search before asking further such easily searchable questions...

There are some tips&tricks in [the rules|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement] for asking good questions...

In future, very easily searchable questions will be deleted.

Cheers,

Julius

Re: what is optimization?

Former Member — Mon, 15 Sep 2008 15:30:59 GMT


> In future, very easily searchable questions will be deleted.

Along with the points given to responses to easily searchable questions??

Rob

Re: what is optimization?

Former Member — Mon, 15 Sep 2008 16:01:02 GMT

Hi Rob,

It depends. I don't like interfering with points, but do remove them when the contents of the posted answer is against the rules as well.

When the quality of the question is so bad (like please send me the doks and links etc) and repeatedly asked then rather avoid them completely as they will with almost certainty be deleted anyway. If it is someone new who perhaps needs to be helped a bit to afterwards help themselves further, then I normally leave them if the intentions were good. As you can see, this one already had some answers.

Of course, if the intentions were not so good then following the trail via the points can be usefull as well... we have some nice tools for this...

I decided to post to this one instead and not to delete it, for all to see as a reminder of "the rules" and not just Pravin when reading a mail from the sapnetworknotifications and then searching first next time.

Cheers,

Julius

Re: what is optimization?

Former Member — Mon, 15 Sep 2008 18:00:55 GMT

My mistake - I thought the points went as well.

Rob

Re: what is optimization?

Former Member — Mon, 15 Sep 2008 18:11:58 GMT


> My mistake - I thought the points went as well.
> 
> Rob

They do sometimes go as well (see above), but usually I just warn and watch it for a while and then if necessary request that everything is taken away - which only happens if a strict procedure for such requests returns sy-subrc = 0

Cheers,

Julius