Question How to output execution time of a query from MongoDB to PHP window

[cafcrob123]

Hi All,

I am a university student and require some help, I have been trying to find out how to show the execution time of simple SQL queries such as insert select delete etc

I have already understood how to insert data into MongoDB but what I need to find now is how to code it so once the code has inserted the data in the DB it shows the time it had taken to perform the insert ,, the preferred way of showing this would be on a php window once the insert button has been clicked,

I hope t hear from you soon

This is the code I have...

$m = new MongoDB\Client("");
$db=$m->PHP;
$collection=$db->Users;

if($_POST)
{

$insert= array(
'name' => $_POST['name'],
'email' => $_POST['email'],
'qebsite' => $_POST['website'],
);

if($collection->insertOne($insert))

{
echo "data is Inserted";
}

else{
echo "some issue";
}

}
else{
echo "No data to store";
}
?>

 

[Pawan]

$before = microtime(true);
    $collection->find( array() );
    $after = microtime(true);
    $execution_mills = $after - $before;
    echo 'Execution time is : ' . $execution_mills;