Hi,
I'm testing the performance of a series of queries in a batch file with and without indexes. I'm doing it like this:
mysql databasename < queries.sql > results.txt
This works fine, but I want to be able to time the queries. Oracle provides the commands 'start time' and 'stop time' that you can include in your SQL statements to achieve this. Is there a similar thing in MySQL, I couldn't find anything in the MySQL manaual :-(
I'm testing the performance of a series of queries in a batch file with and without indexes. I'm doing it like this:
mysql databasename < queries.sql > results.txt
This works fine, but I want to be able to time the queries. Oracle provides the commands 'start time' and 'stop time' that you can include in your SQL statements to achieve this. Is there a similar thing in MySQL, I couldn't find anything in the MySQL manaual :-(