You can translate the question and the replies:

Intermittent Failure of Base View with Timeout

We have a view that works sometime, retrieves the selected sql table and delivers, then, at random times, takes over 5min and times out with a failure. The name of the view that fails to complete contains the phrase: perf_updown_capture_chart_5yr. The error happened on 9/29 at ~9:29AM. We have the vdp log table and can attach the file to examine log records.
SQL
user
30-09-2022 10:25:28 -0400
code

1 Answer

Hi, I would recommend you to check the execution trace to understand more about the bottleneck. You can refer to the [Best Practices to Maximize Performance IV: Detecting Bottlenecks in a Query](https://community.denodo.com/kb/en/view/document/Best%20Practices%20to%20Maximize%20Performance%20IV%3A%20Detecting%20Bottlenecks%20in%20a%20Query) page of the Knowledge Base for more information about detecting a bottleneck. Analyzing logs for detecting a bottleneck of your timeout issue may take more time and technical investigation, so if you are a valid support account, I suggest you open a new case in the [Denodo Support Site](https://support.denodo.com/) so the Denodo team can help you. Hope this helps!
Denodo Team
03-10-2022 04:39:42 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here