下面是用于连接数据库和获取数据的JS代码。
我可以使用node db.js
命令在终端中运行整个代码,并测量总执行时间,但我想测量的是每块代码在毫秒内执行要花费多长时间:
# Part 1:
var mysql = require('mysql');
# Part 2:
var connection = mysql.createConnection({
host: '...',
user: '...',
password: '...'
port : ...
database: '...'
});
# Part 3:
connection.connect(function(err) {
if (err) throw err;
connection.query("SELECT * FROM table", function (err, result, fields) {
if (err) throw err;
console.log(result);
});
connection.end();
});
如何测量上面的每个部分?
谢谢。
最佳答案
您可以使用console.time('name')
和console.timeEnd('name')
来测量代码中两个位置之间的时间。
看起来像这样:
console.time('part1') //start timer for part 1.
var mysql = require('mysql');
console.timeEnd('part1') //end timer 1 and log how long it took.
console.time('part2') //start timer for part 2.
var connection = mysql.createConnection({
host: '...',
user: '...',
password: '...'
port : ...
database: '...'
});
console.timeEnd('part2') //end timer 2 and log how long it took.
console.time('part3') //start timer for part 3.
connection.connect(function(err) {
if (err) throw err;
connection.query("SELECT * FROM table", function (err, result, fields) {
if (err) throw err;
console.log(result);
console.timeEnd('part3') //end timer 3 in the callback and log how long it took.
});
connection.end();
});