Api calls are slow while using nodejs + mysql?

I am really a newbie while considering api development ,its been 2 weeks since I have started .The api which I have developed is supposed to take all(just 35) the column from a table ,but it takes 825ms.Its comparatively 300ms slower than laravel. Node is supposed to be faster than laravel .Any help is very much apppreciated.

my db connection:

var mysql = require("mysql");  var db;  function connectDatabase() {    if (!db) {      db = mysql.createConnection({      port:process.env.DB_PORT,      host:process.env.HOST,      user:process.env.DB_USERNAME,      password:process.env.DB_PASSWORD,        database:process.env.DATABASE,             });            db.connect(function(err) {        console.log(err);        if (!err) {          console.log("Database is connected!");        } else {          console.log("Error connecting database!");                  }      });    }    return db;  }    module.exports = connectDatabase();  

My SP call:

VIEW_CATEGORY: (body, callBack) => {     let Api_token = body.api_token;                pool.query(        "CALL View_Data(?,?,@a);",        ["category",Api_token],        (error, results, fields) => {                     if (error) {                callBack(error);          }          else{            return callBack(null, results[0]);          }        }      );    }  

My SP query

CREATE DEFINER=`NodeApi`@`%` PROCEDURE `View_Data`(IN tablenamenew varchar(30),IN apitoken varchar(500),OUT err_id varchar (10))  BEGIN  if exists (select 1 from employee where api_token = apitoken) then  SET @t1 =CONCAT('SELECT * FROM ',tablenamenew);   PREPARE stmt3 FROM @t1;   EXECUTE stmt3;   DEALLOCATE PREPARE stmt3;  else  set err_id = "-1";  select err_id;  end if;  END  

Duration: TCP handshake:260ms Transfer start:270ms Download:267

Kindly help if possible

https://stackoverflow.com/questions/66139935/api-calls-are-slow-while-using-nodejs-mysql February 10, 2021 at 11:31PM