× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Performance Tunning

  • ironmaiden
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
18 years 2 months ago #800 by ironmaiden
Performance Tunning was created by ironmaiden
Dear Tigers,


Does any one have the List of rules for Tunning a routine. Rather is there any statndard procedure for performance tunning. Any documents, info about this is welcome...
_________________
NJOY LIFE TO THE FULLEST

Please Log in or Create an account to join the conversation.

More
18 years 2 months ago #801 by malai
Replied by malai on topic Performance Tunning
Hi Iron,

In my opinion, most of the codes in GLOBUS were not atall undergone performance testing. But even temenos has given some set of standards for tuning the performance. Here are below.

Coding Standards

1. A template routine should not exceed 2000 lines.
2. A call subroutine should not exceed 600 lines.
3. A GOSUB block should not exceed 100 lines.
4. A IF condition block shoud not exceed 60 lines.

Performance Tuning

1. FOR..NEXT should be replaced with LOOP..REMOVE ( if applicable).
2. EXECUTE or PERFORM should be replaced with CALL ( if applicable). Because it will create its own memory space.
3. In some cases READ is better than F.READ and WRITE is better than F.WRITE.
4. Dont put big codes between a TRANSSTART and TRANSEND.
5. While developing BATCH programs use multithreading (SELECT,LOAD...)
6. In jbase we have 1 utility 'jprof' which tells which part of code consumes how much amount of time.

Still many more...
If I am not wrong, there is no documents telling this.
_________________
M A L A I

Please Log in or Create an account to join the conversation.

  • ironmaiden
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
18 years 2 months ago #802 by ironmaiden
Replied by ironmaiden on topic Performance Tunning
Hi Malai,

Also to add upon

SELECT Statment
SELECT <FileVariable> is faster than EXECUTE 'SELECT ....' which is faster that our famous EB.READLIST

OPEN Statement
Multiple OPEN statments with LOOP or FOR conditions. This will also cause performance issue.

Some codings standards are
Use decrement instead of increment
Use i =+1 format instead of i = i + 1

I will update these standards As and when i come across
_________________
NJOY LIFE TO THE FULLEST

Please Log in or Create an account to join the conversation.

More
18 years 2 months ago #803 by malai
Replied by malai on topic Performance Tunning
Hi

I got some more.

don't use DBR especially in a loop and avoid EB.PRINT to create reports.
_________________
M A L A I

Please Log in or Create an account to join the conversation.

Time to create page: 0.105 seconds