how to get the complete time when I run a sql script using monetdb

Question

when I use the command-line interface of sql after I type "mclient -dmydatabase", if I type the "select...." instruction directly, I will get the complete time like this

(query result)

7 tuples (15.4s)

but if I put the same instruction into the sql script like default_22.sql, after I run the script I will only get the answer without the time like this:

(query result)

7 tuples

so I hope to know that how can I get the complete time when I run the script using the monetdb? thank you.

Answer 1

You could use the -i flag e.g.

mclient -dmydatabase -i scriptfile