You can translate the question and the replies:

Complex query that return a time out in VDP

Hello, I have a query like that: ``` SELECT t1.* FROM elements t1 WHERE ( ( t1.name IS NULL OR t1.name = '' ) AND t1.id NOT IN ( SELECT t2.id FROM elements t2 WHERE ( t2.name IS NOT NULL AND t2.name <> '' ) ) ) ``` And VDP returns a time out, but If I run this query in a database, it runs properly. Could be another way to do that?
SQL
user
03-07-2019 10:20:10 -0400

1 Answer

Hi, You could figure out which step in the execution is taking more time by checking the execution trace. Once this is figured out, some adjustments can be made in the particular view's setting to make sure that the execution is operating at the optimum level. Also, you could work on changing the timeout. If you are using Virtual DataPort Admin tool to query Virtual DataPort Server, you can set the timeout under ‘Tools > Admin Tool Preferences > Connection > Query Timeout’. If you are using any other external clients, verify the timeout at the client level. You can override the timeout configured in Admin Tools setting for your query by using a QUERYTIMEOUT argument at the VQL CONTEXT Clause level. Please refer to https://community.denodo.com/docs/html/browse/6.0/vdp/vql/queries_select_statement/context_clause/context_clause#context-clause for more details. Hope this helps!
Denodo Team
04-07-2019 07:43:26 -0400
You must sign in to add an answer. If you do not have an account, you can register here