I am trying to measure execution times of my query. The problem is that the measuting times don't actually incorperate the query it just skips. For example my page loads for 2 seconds but in the console i get 24 miliseconds. Have tried in multiple methods as shown in the code below but none of them work.
Have also gone through multiple already made questions on stackoverflow and other websites but can't find the right solution.
I am also measuring execution times of a MongoDB query in Node.js but there it works. I don't why it doesn't work here and tried everything.
console.time("time");
var startTime = performance.now();
var startTime2 = Date.now();
var startTime3 = new Date().getTime();
var startTime4 = process.hrtime();
for(var i = 0; i < 10000; i++){
const selectForum = conn.query(
"SELECT forum_id, forum_name, post_date, forum.user_id, user.user_id, user_name FROM forum LEFT JOIN user ON forum.user_id=user.user_id ORDER BY forum_id DESC"
);
}
var endTime = performance.now();
console.timeEnd("time");
console.log(`${endTime-startTime} ms with performance.now`);
var endTime2 = Date.now();
console.log(`${endTime2-startTime2} ms with Date`);
//with getTime
var endTime3 = new Date().getTime();
console.log(`${endTime3-startTime3} ms with getTime`);
//with hrtime
var endTime4 = process.hrtime(startTime4);
console.log(`${(endTime4[1] - endTime4[0]) / 1000000 } ms with hrtime`);
This is my full query i am using but it still doesn't work.
console.time("time");
var startTime = performance.now();
for(var i = 0; i < 10000; i++){
const selectForum = conn.query(
"SELECT forum_id, forum_name, post_date, forum.user_id, user.user_id, user_name FROM forum LEFT JOIN user ON forum.user_id=user.user_id ORDER BY forum_id DESC", function (err, result){
if (result && result.length) {
console.log(result);
} else {
console.log(err);
}
});
}
var endTime = performance.now();
console.timeEnd("time");
console.log(`${endTime-startTime} ms with performance.now`);
