Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $time = microtime(true);
- $dsn = 'mysql:dbname=symfony_live;host=127.0.0.1';
- $user = 'root';
- $password = '';
- $con = new PDO($dsn, $user, $password);
- $connect_time = microtime(true);
- $result = $con->query('SELECT * FROM user WHERE username LIKE "foobar"');
- $query_time = microtime(true);
- var_dump($result->fetchAll(PDO::FETCH_ASSOC));
- $time_con = ($connect_time - $time) * 1000;
- $time_query = ($query_time - $connect_time) * 1000;
- echo "Connection took $time_con msn";
- echo "Query took $time_query msn";
- Connection took 2.5701522827148 ms
- Query took 1.1160373687744 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement