Hi all!
+2My benchmark consists of 1000 lines of identical queries with 3 seconds delay between them. Most queries returns the result in a short time (~ 6 ms) but some queries delay answer to 15000 ms. Than this may be due and how to check and eliminate this delay?
+2Hi,
If you have the transaction_id, statement_id and initiator node of the slower query ( You could also get that info from the query_profile table) you could check where the query took time and depending on the phase it can be many things. The below query will show you the time in each of the phases,
If you have the transaction_id, statement_id and initiator node of the slower query ( You could also get that info from the query_profile table) you could check where the query took time and depending on the phase it can be many things. The below query will show you the time in each of the phases,
select node_name,execution_step,completion_time-time as duration from dc_query_executions where transaction_id= <transaction_id> and statement_id = <statement_id> and node_name ilike '%<initiator_node> ' order by time;
let us know where do you see the delay.
Eugenia
+2Thank you very much!
I will analyze this table. I wonder why the same questions selected from a file, give a a wide scatter runtime.
Igor
I will analyze this table. I wonder why the same questions selected from a file, give a a wide scatter runtime.
Igor
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
