Performance of Redshift Stored Procedure is not upto mark

Hi All, In my stored procedure, I have scursor which loops through the table and each record will go through many IF Conditions and as per result I will move further using fetch next while being inside loop itself.I am not able to do BULK UPDATE cause my requirement demand row level processing.It is performing good for just One id, but i have large number of ids which needs to be processed by this sp and time taken is beyond the expectation.How to speed up this stored procedure in Redshift?

Jon Roberts エキスパート
2年前
Row by row processing is not ideal in Redshift or really any MPP database. Can you provide sample code and maybe we can help you convert it into a set based approach?

トピック

分析計算するデータベース

タグ

分析ハイパフォーマンスコンピューティングデータの抽出、変換、ロード Amazon Redshift

言語

English

AWS-User-0658229

質問済み 2年前539ビュー

1回答

新しい順
投票が多い順
コメントが多い順

これらの回答は役に立ちましたか？コミュニティがあなたの知識を活用できるように、正解に賛成票を投じてください。

Hello,

Thank you for posting your question.

To further dive deep on the specifics of the slow execution of this stored procedure, I would ask that you open a support case and include the output of:

SHOW PROCEDURE sp_name

Reference: https://docs.aws.amazon.com/redshift/latest/dg/r_SHOW_PROCEDURE.html

AWS_Dylan

回答済み 2年前

Performance of Redshift Stored Procedure is not upto mark

関連するコンテンツ