Re: Need to Check MySql Query Time from Hibernate

[Oliver Gray]

If you want to check the execution time in your project, you can use microtime() to calculate start and end times as:

MYSQLi example:

<?
$link = mysqli_connect("localhost", "yourUser", "yourPassword", "yourDB");
$SQL = "SELECT * FROM yourQuery";
$start = microtime(true);
mysqli_query($link,$SQL);
$end = microtime(true) - $start;
echo $end; // result in seconds
?>

Did I hear you right ?