Skip to Content
author's profile photo Former Member
Former Member

How ADBC connection is benefits by using SAP HANA as secondary database ?

Hi,

I have one more important question.


How ADBC connection is benefits by using SAP HANA as secondary database in terms of performance wise for the access of data from HANA database as a secondary database.


I have 2 options and which is better for the good performance for accessing the data-


1 . In ABAP Reports in the SELECT statements by using CONNECTION (“HDB”) will this improve the
performance.
e.g : select * from BSEG into TABLE IT_TAB CONNECTION (“HDB”).

2. Will Create the Stored procedure in HANA studio and Call
from ABAP as below by using NATIVE SQL–

EXEC SQL

SET CONNECTION (‘HDB’).

ENDEXEC.

EXEC SQL.

EXECUTE PROCEDURE proc (IN p_in1
OUT p_out1 OUT p_out2 )

ENDEXEC.


Regards,
Pravin

Message was edited by: Jens Weiler Branched from http://scn.sap.com/thread/3498161

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on May 16, 2014 at 06:34 PM

    Hi Pravin,


    Option 1: In this case ADBC might even worsen the performance due to the overhead in the ADBC framework. OpenSQL is the method to go here, as OpenSQL - from the ABAP point of view - features the optimal communication with the database while ADBC has overhead like constructor-calls for the statement, parameter binding, etc.

    Option 2: In this case ADBC is comparable with EXEC SQL but features more options, e.g. clean concept of multiple connection (connection objects via CL_SQL_CONNECTION), exception handling, etc. So I strongly propose to favour ADBC over EXEC SQL, but not simply for performance reasons. You might have a look at the ABAP Language Help in your system on more information on ADBC and the advantages over Exec SQL.

    Cheers,

    Jasmin


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.