Performance Tuning

[shivaprasath143]

What are all the ways we can improve the performance of our process ?

 

[RealHeavyDude]

Don't start the process. No process - no performance issues :awink:

 

[TomBascom]

This is a huge subject area.

You need to refine your inquiry.

 

[shivaprasath143]

while report generation if we have any performance isssues.. how to solve it ?

 

[TomBascom]

Start by determining where the time is going. The profiler is very handy for that purpose.

 

[RealHeavyDude]

Again you question is way to generic. Bad performance can come from a badly configured database, but - YMMV - most times I saw performance issues they came from bad application code and/or bad logical database design.

You need to pin down where the performance problems come from to be able to develop an action plan to solve them.


Heavy Regards, RealHeavyDude.

 

[shivaprasath143]

what are all the ways we can identify the issues?

 

[TomBascom]

One of the best ways is to talk to your users and find out what they are unhappy about. Things which are repeatable and measurable are priceless. Stuff like "when I run the xyz report with X criteria it always takes N minutes and that is too long". Or "when I press 'ok' on the abc screen my system does not respond for N seconds".