what is optimization?

[Former Member]

Hi gurus,

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

Thanks in advance.

[ThomasZloch]

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

[Former Member]

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

[Former Member]

Hi,

Check thi slink for performance optimization related links-

/thread/1010274 [original link is broken]

[Former Member]

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

[Former Member]

>

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

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

Rob

[Former Member]

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

[Former Member]

My mistake - I thought the points went as well.

Rob

[Former Member]

>

> 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