Skip to Content
author's profile photo Steve Lamb
0
Steve Lamb

Tuning HANA for intense queries

Posted on Feb 16, 2018 at 01:57 PM 97 Views Last edit Feb 16, 2018 at 02:22 PM 2 rev.

I have a single UPSERT query that can update possibly 300 million records in one table from another table. When I run this, it seems that HANA becomes starved of CPU resources. Is there a way to tune HANA so queries like these can be run without pegging the CPU and other system resources? I know I can batch the query but this significantly adds to the amount of time it takes the query to finish

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Lars Breddemann
    Lars Breddemann
    Posted on Feb 16, 2018 at 09:56 PM
    0

    OK, so you want HANA not to use up the CPU time but also not take longer than with using the CPU, is that correct?

    If so, then it’s time again for the good old GOFAST-hint...

    Just kidding. Look, you have provided no information about your system, the table structure, the upsert statement, the HANA version... all we know by now is your storytelling of an UPSERT statement that doesn’t work like you think it should. And that’s just too little information to make any recommendations.

    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.