Advertisement
Guest User

Untitled

a guest
Jul 6th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. $time = microtime(true);
  2.  
  3. $dsn = 'mysql:dbname=symfony_live;host=127.0.0.1';
  4. $user = 'root';
  5. $password = '';
  6.  
  7.  
  8. $con = new PDO($dsn, $user, $password);
  9.  
  10. $connect_time = microtime(true);
  11.  
  12. $result = $con->query('SELECT * FROM user WHERE username LIKE "foobar"');
  13.  
  14. $query_time = microtime(true);
  15.  
  16. var_dump($result->fetchAll(PDO::FETCH_ASSOC));
  17.  
  18. $time_con = ($connect_time - $time) * 1000;
  19. $time_query = ($query_time - $connect_time) * 1000;
  20.  
  21. echo "Connection took $time_con msn";
  22. echo "Query took $time_query msn";
  23.  
  24. Connection took 2.5701522827148 ms
  25. Query took 1.1160373687744 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement