Skip to Content

Memory Consuming by Stored Procedure

Hi all,

I am using a stored procedure to extract data by a calculation view and to store the result into columns table.

I move very large quantity of data and table can have 10/15 million record, the extraction can move 1/2 million record each times.

This is my SQL statement:

insert into "SCHEMA"."TABLE"

( Select "F1", "F2"... from Calculation_View )

During this loading process I can see the RAM consuming is heavy and I would like to know if is possible to unload RAM memory allocated when I finish the procedure, how can I reduce the RAM consuming after the procedure's execution?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 28, 2017 at 05:47 AM

    This sounds a lot like your approach of copying data is not working well for you.

    Why do you do this in the first place?

    With HANA there usually is no need to manually manage the memory - if you load too much data for your HANA system, then you will run into issues, no matter what. So, rather look into why you use up that much memory in the first place.

    Add comment
    10|10000 characters needed characters exceeded

    • That's likely just going to be the band-aid here.

      You might as well trigger the delta merge for this table specifically once you loaded your data in. To hold off the automatic merge while the insert runs, you may even disable the AUTOMERGE of the table.

      However, the 1 million resulting records are probably not the issue. It's more likely that computing those is the problem.