expensive node_load called twice in the node_revision_delete

API page: https://api.drupal.org/api/drupal/modules%21node%21node.module/function/...

Problem
node_revision_delete is doing a expensive call to node_load to prevent deleting the current revision instead we can just query the node table based on node id and get the revision id(vid) back.

Proposed resolution
$node = db_select('node', 'n')
->fields('n', array('vid'))
->condition('nid', $revision->nid,'=')
->execute()
->fetchObject();