[MonetDB-users] measure performance time
Hi, I need to measure the sql query execution time of several queries. The mclient "-t" option does not exist in the newer version, and the "\< file_with_queries" SQL command does not seem to show the time when importing from a file. Any ideas?? -- View this message in context: http://old.nabble.com/measure-performance-time-tp33201681p33201681.html Sent from the monetdb-users mailing list archive at Nabble.com.
On 25-01-2012 07:02:09 -0800, jfergar wrote:
I need to measure the sql query execution time of several queries. The mclient "-t" option does not exist in the newer version, and the "\< file_with_queries" SQL command does not seem to show the time when importing from a file. Any ideas??
use the -ims option to mclient, that might simulate what you want
Thanks but the -ims option does not exists. -i enter the interactive mode, -s allows for a single statement in comand line (but it doesn't show the time) and -m is an incorrect option. Fabian Groffen wrote:
On 25-01-2012 07:02:09 -0800, jfergar wrote:
I need to measure the sql query execution time of several queries. The mclient "-t" option does not exist in the newer version, and the "\< file_with_queries" SQL command does not seem to show the time when importing from a file. Any ideas??
use the -ims option to mclient, that might simulate what you want
------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- View this message in context: http://old.nabble.com/measure-performance-time-tp33201681p33206631.html Sent from the monetdb-users mailing list archive at Nabble.com.
On 26-01-2012 02:44:42 -0800, jfergar wrote:
Thanks but the -ims option does not exists. -i enter the interactive mode, -s allows for a single statement in comand line (but it doesn't show the time) and -m is an incorrect option.
Sorry, I assumed you were on the Dec2011 branch already, where this feature was introduced.
participants (2)
-
Fabian Groffen -
jfergar