Skip to Content

Native SQL VS Open SQL where condition performance

Hello,

I am learning CDS right now. However i want to know if there is any performance issue when passing parameters trough open SQL instead of native SQL. In other words what is the performance advantages of creating a view with parameters instead of passing the parameter in the Open SQL?

Thanks

Shabir

SQL
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 20, 2017 at 01:37 AM

    Well, what's the benefit of using OpenSQL vs. native SQL? OpenSQL does a lot of additional 'handy work' like statement caching, session parameter handling, table buffering etc.. There is management overhead but that is typically covered by the time/memory savings you gain from statement caching.

    Using ABAP CDS is not meant to be a query runtime performance improvement. Instead, it's about how you develop and deploy your application.

    In my experience it's easiest not to mix between the different development approaches too much - else you lose the benefits of having an easy to manage environment without tangible benefits otherwise.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09, 2017 at 04:36 PM

    Sell more HD and CPU? I don't know :)

    Perhaps we're talking about the same thing and I'm looking for an answer same as you, but generally I think that OPEN SQL is able to talk to different Database systems that are behind SAP and is portable.

    When you write an ABAP program with Open SQL statements the kernel SAP programs convert this statement into native SQL for database in use, so technically there's a loss of time, but with no perception with modern technology.

    The More you talk in machine language and the less time you'll have to wait for a reply, if you talk in an empty room :)

    Hope to help

    Bye

    Add comment
    10|10000 characters needed characters exceeded