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