Earn Money
Trading Forex Online
Paramount Airways
Free Data Recovery
Cargo
Job Portal
HSBC Investment
Management
Cheap Web Hosting
Make Trip
Cheap Air Travel
Leisure Hotel
Free Air Travel
Mutual Fund Informations
Cheapest Cellular Plan
Free Sexy Indians
Call Center Software
Hot Indian
|
Programming Help |
Homework Help |
Counseling
Astrology Advice |
Tarot Advice |
Parenting
Dating Advice |
Love Advice |
Divorce Advice
Legal Advice |
Debt Advice |
Career Advice
whether to write the data to memory or swap space. See the Fieldgroups ABAP
example.
Use as many table keys as possible in the WHERE part of your select statements.
Whenever possible, design the program to access a relatively constant number of
records (for instance, if you only access the transactions for one month, then there
probably will be a reasonable range, like 1200-1800, for the number of transactions
inputted within that month). Then use a SELECT A B C INTO TABLE ITAB
statement.
Get a good idea of how many records you will be accessing. Log into your productive
system, and use SE80 -> Dictionary Objects (press Edit), enter the table name you
want to see, and press Display. Go To Utilities -> Table Contents to query the table
contents and see the number of records. This is extremely useful in optimizing a
program's memory allocation.
Try to make the user interface such that the program gradually unfolds more
information to the user, rather than giving a huge list of information all at once to the
user.
Declare your internal tables using OCCURS NUM_RECS, where NUM_RECS is the
number of records you expect to be accessing. If the number of records exceeds
NUM_RECS, the data will be kept in swap space (not memory).
Use SELECT A B C INTO TABLE ITAB whenever possible. This will read all of the
records into the itab in one operation, rather than repeated operations that result
from a SELECT A B C INTO ITAB... ENDSELECT statement. Make sure that ITAB is
declared with OCCURS NUM_RECS, where NUM_RECS is the number of records
you expect to access.
Many tables contain totals fields (such as monthly expense totals). Use these avoid
wasting resources by calculating a total that has already been calculated and stored.
Program Analysis Utility
To determine the usage of variables and subroutines within a program, you can use the
ABAP utility called `Program Analysis' included in transaction SE38. To do so, execute
transaction SE38, enter your program name, then use the path Utilities -> Program
Analysis
ABAP PERFORMANCE IMPROVEMENTS VIA DATA DICTIONARY
INDEX CREATION SUGGESTIONS RELATED TO DATABASE PERFORMANCE
· The columns at the beginning of an index are the most "common". The most
"common" columns are those where reports are selecting columns with no ranges - the
where clause for these columns is an "equal to" expression. Rearrange columns of an
index to match the selection criteria. For example, if a select statement is written to
include columns 1 and 2 with "equal to" expressions in the where clause and column 3
|
Earn Money
Trading Forex Online
Paramount Airways
Free Data Recovery
Cargo
Job Portal
HSBC Investment
Management
Cheap Web Hosting
Make Trip
Cheap Air Travel
Leisure Hotel
Free Air Travel
Mutual Fund Informations
Cheapest Cellular Plan
Free Sexy Indians
Call Center Software
Hot Indian
|
