Why does the function overload all the server's RAM?

Question

JavaScript

There is a code:

async function checkQuery(object) {
  i = 0;
  while (i < urls[1].length) {
    sql = 'SELECT id FROM cases WHERE case_number="' + urls[2][i] + '"';
    await connection.execute(sql, function(err, results, fields, rows) {
      //console.log('... . Ошибка: ' + err + ', Данные: ' + results[0].objid + ', мета-данные полей: ' + fields + '.');
      if(results[0] === undefined) {
        console.log('Совпадение не найдено');
        i++;
      } else {
        console.log('Такое дело есть!');
        urls[0].splice(i, 1);
        urls[1].splice(i, 1);
        urls[2].splice(i, 1);
      }
    });  
  }
  console.log(urls[2].length);
}

When it is executed, the entire server memory is loaded and it displays 'killed' in the console

Answer 1

Take the sql query out of the loop
Try first to get all urls[2][i] and write them into one array (array1) so that there is a single list /
Then try to execute a query like: SELECT id FROM cases WHERE case_number in ( array1.join(' ,') )