Search
Home
Saved
Top Charts
Books
Audiobooks
0
320 views
Sign In
Upload
Join
RELATED TITLES
0
HANA Golden Rule and Performance Guidelines for ABAP Development on ..
Uploaded by Narendra Pratap ABAP on HANA Advanced
Golden Rule of HANA
Save
Embed
Share
Print
05 HANA_Student
End to End Development
Magazines
News
Documents
1
Download
of 4
8/28/2014
Search document
Per for mance Gui deli nes for ABAP Devel opment on ... | SCN Getti Get ting ng St Start arted ed
Hi, Guest
Sheet Music
Log Lo g On On
Search the Communit
Join Jo in Us
Products
Services & Support
About SCN
Downloads
Indus tries
Traini ng & Education
Partners hi p
Developer C enter
Lines of Bus ines s
Univers ity Alli ances
Events & Webinars
Innovation
Activity Brow Bro w se
ABAP for SAP HANA
Performance Guidelines for ABAP Development on the th e SAP HANA Database Posted Post ed by Eric Westenberger in ABA in ABAP P for SAP SAP HANA on Mar 24, 2013 5:46:33 PM Share
2
1
Tweet
If you you are an experienced experienced ABAP ABAP Developer, Developer, then you you mos t likely know the class ical performance guidelines for using Open Open SQL (if not, n ot, then you should look them up immediately). One of the freq uently asked ques tions we receive is: “What “What changes change s in the context of SAP HANA regarding these guidelines?” Let us first reconsider the existing guidelines. In a nutshell, they are usually sum marized in the “ 5 golden rules ”: Icon
Rule
Details / Examples
Keep the result sets
Do not retrieve retrieve rows from the database and dis card them on the
small
application server using CHECK or EXIT, e.g. in SELECT loops Make the WHERE clause clause as specific as pos sible
Minimize amount of
Use SELECT with with a f ield ield lis t instead of SELECT * in order to transfer
transferred data
jus t the columns you really need Use aggregate functions functions (COU (COUNT, NT, MIN, MIN, MAX, SUM, AVG) instead of transferring all the rows to the application server
Minimize the
Use JOINs and / or sub-queries ins tead of nested SELECT SELECT loops
numberr of data numbe
Use SELECT … FOR ALL ALL ENTRIES ENTRI ES inste instead of lo l ots of SELECTs or
transfers
SELECT SINGLEs
Sign up to vote on this title
Use array variants variants of INSERT, UPDATE, MODIFY MODIFY,, and DELETE
Minimize Mini mize the sear ch overhead
Define and us e appropriate secondary indexes
Useful
Not useful
Com
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Upload
Sign In
Join
Search
Home
Saved
Top Charts
Books
Audiobooks
320 views
0
Sign In
Upload
Join
RELATED TITLES
0
HANA Golden Rule and Performance Guidelines for ABAP Development on ..
Uploaded by Narendra Pratap ABAP on HANA Advanced
Golden Rule of HANA
Save
Embed
Share
Print
05 HANA_Student
End to End Development
Magazines
News
Documents
Download
1
8/28/2014
of 4
Search document
Performance Guidelines for ABAP Development on ... | SCN
Details and background information on adapted guidelines (to come)
Sheet Music
Frequently Asked Questions for ABAP Developme nt on SAP HANA (to come)
The following recommendations are derived from measurem ents and experiences bas ed on SAP Business Suite usi ng SAP NetWeaver AS ABAP 7.4 runni ng on SAP HANA SPS5. They will be a dded to the standard ABAP 7.4 documentation and also s upported in standard tools s uch as the ABAP code inspector. Guideline
Additions in the context of SAP HANA As on all databas e systems , there is a performance overhead ass ociated with every databas e access for connection handling, SQL parsing, execution plan determination, etc. The following exis ting guidelines s hould be prioritized higher on SAP HANA: For modifying operations (INSERT, UPDATE, DELETE) using array operations should be preferred to single operations when changing many data records Nested SELECT loops should be avoided or replaced if possible by Changing the nes ted single SELECT statement to an appropriate SQL construct (e.g. FOR ALL ENTRIES, JOIN, su b-query, etc.) Avoiding rep eated access to the same data via SQL Using the ABAP table buffer (see existing guidelines for the ABAP table buffer) In most cases, SAP HANA does not require secondary indices for good search performance. To reduce main mem ory consumption, and to im prove insert performance all existing nonunique secondary database indices on columnar tables are removed during migration or do not get created during installation for all AS ABAP systems from SAP NetWeaver 7.4 onwards. For some us e cases secondary indexes can s till be beneficial. This is especially true for highly selective queries on non-primary key fields. These queries can be s ignificantly improved by indexes on single fields which are m ost selective. SAP Note 1794297 describes the procedure to find and create these indexes. The guideline is renamed to "Keep load away from the database, but push data-intensive calculations to the database where applicable" On SAP HANA, it is beneficial to move data-intensive calculations into the database.
You're Reading a Preview
Nevertheless, it is not recommended to execute the same operations redundantly, e.g. in different user contexts or different dialog steps of the same user. Meaningful buffering of results on the application server should be applied.
Unlock full access with a free trial.
The following recommendation should be considered in this light on SAP HANA
Download With Free Trial
Sorting data:In general, the recommendations for sorting remain as before, i.e. if the database does not use the same index for sorting as for selection, then it may be in som e situations more efficient to sort in the application server in particular if all data to be sorted has to be fetched from the application server anyway. However, if the sorting is part of determining the result set (e.g. select top n customers by revenue) or the sorting is part of a larger calculation Sign up logic (e.g. within a procedure), it should be done in SAP HANA.
Useful
As outlined above, the next post contains s ome m ore technical backgrou nd informatio n for the reaso ning behi nd these recommendations, and som e answers to frequently asked questions .
to vote on this title
Not useful
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Upload
Sign In
Join
Search
Home
Saved
Top Charts
Books
Audiobooks
320 views
0
Sign In
Upload
Join
RELATED TITLES
0
HANA Golden Rule and Performance Guidelines for ABAP Development on ..
Uploaded by Narendra Pratap ABAP on HANA Advanced
Golden Rule of HANA
Save
Embed
Share
Print
05 HANA_Student
End to End Development
Magazines
News
Documents
1
Download
8/28/2014
of 4
Search document
Performance Guidelines for ABAP Development on ... | SCN Is a database view the only option?
Sheet Music
Regards, Patrick Like (0)
Hermann Gahm Mar 31, 2013 6:25 PM (in response to P. van Os)
Hi Patrick, the note can be beneficial in some cases . Regarding the FAE with the join there is no hint necessary / available. A join / view (avoiding the FAE) can (but does not have to) be beneficial . I would recom mend to try different variants. It also depends on the version of HANA that you have in use since FAE processing in HANA might be different. Kind regards, Hermann Like (1)
Abdul Hakim Apr 5, 2013 1:34 PM
Nice blog. Looking forward to future blog s eries in this topic. Thanks Abdul Hakim Like (0)
Suhas Saha Apr 26, 2013 11:08 AM
Looking forward to the next blog in the series. A lil' bit of ABAP code won't harm anyone BR, Suhas Like (1)
You're Reading a Preview Hermann Gahm May 18, 2013 7:56 PM (in response to Suhas Saha)
Hi, next posts will contain some ABAP. Hope i will find s ome time to s tart them.
Unlock full access with a free trial.
Download With Free Trial
Kind regards, Hermann
Sign up(1)to vote on this title Like
Camille Bommart Oct 9, 2013 2:53 PM
Hello Hermann
Useful
Not useful
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Upload
Sign In
Join
Search
Home
Saved
Top Charts
Books
Audiobooks
320 views
0
Sign In
Upload
Join
RELATED TITLES
0
HANA Golden Rule and Performance Guidelines for ABAP Development on ..
Uploaded by Narendra Pratap ABAP on HANA Advanced
Golden Rule of HANA
Save
Embed
Share
Print
05 HANA_Student
End to End Development
Magazines
News
Documents
1
Download
of 4
8/28/2014
Search document
Performance Guidelines for ABAP Development on ... | SCN Camille Bommart Oct 9, 2013 4:03 PM (in response to Hermann Gahm)
Thank you very much
Sheet Music
Like (0)
Venkatesan Parasuraman Nov 6, 2013 9:08 PM
Thank you very much, this is helpful Like (0)
Peter Inotai Nov 21, 2013 11:04 AM
Hi Eric, Very great su mm ary! Is there any change regarding fully buffered tables (eg customizing tables)? Or everything stays the same (except that it's also in memory in DB side)? Thanks, Peter Like (0)
Hermann Gahm Nov 25, 2013 10:14 AM (in response to Peter Inotai)
Hi Peter, regarding buffered tables there is no change for the golden rules. We continue to use them like we did in the past. Local application server memory access (buffered table in-mem ory of the local application server) is still faster than remote mem ory access of the table inmemory of the databse server. With SAP Netweaver 7.4 there is a new table buffer based on internal tables that allows to have secondary indexes in the table buffer. With that we have even more buffering options. Kind regards, Hermann Like (1)
You're Reading a Preview
Peter Inotai Nov 25, 2013 12:54 PM (in response to Hermann Gahm)
Hi Hermann, Thanks a lot for this clarification. Peter
Unlock full access with a free trial. Like (0) Download With Free Trial
Sign up to vote on this title
Site Index Privacy
Contact Us Terms of Use
SAP Help Portal Legal Disclosure
Copyright
Useful
Not useful
Home
Saved
Top Charts
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Upload
Sign In
Join
