I tried to execute it with a file (Q.sql) containing more than one query, it seems that it gives me the total execution time with the number of tuple for the last query in the file. Is there something else to do in order to get the execution time of each of the queries. mclient -i -u monetdb -d voc query.sql | tail -n1 Best regards,Baraa
Date: Sun, 13 Oct 2013 16:50:08 +0200 From: martin@monetdb.org To: users-list@monetdb.org Subject: Re: Query execution time
On 10/13/13 4:41 PM, Stefan Manegold wrote:
GREAT EXPLICATION! Thanks for this helpful and clear explication. I think it's very benificial to add it somewhere on the documentation of MonetDB (if it's not already the case); I spent three days googling and trying to understand how is that works. See: http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming Clear enough? The explanation of "time" is on its man page. We'll consider adding the explanation of mclient's "-i" option to its man page.
I have one more question please, what if I have more that one query in my Q.sql? can I get the time (2: reported by mclient -i option) for each of the queries or I can only get the total time? unless you have more than one query per line, you'll get individual times.
Stefan
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list