Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- define("DB_HOST", "localhost");
- define("DB_USER", "root");
- define("DB_PASSWORD", "");
- define("DB_NAME", "classifydb");
- function microtime_float() {
- list($usec, $sec) = explode(" ", microtime());
- return ((float) $usec + (float) $sec);
- }
- $time_start = microtime_float();
- $sql = 'SELECT SQL_CACHE * FROM `' . DB_NAME . '`.`lang` WHERE `default` = 1';
- $db = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME . ';charset=utf8', DB_USER, DB_PASSWORD);
- $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $count = 0;
- while (true) {
- $sth = $db->prepare($sql);
- $sth->execute();
- while ($result = $sth->fetch(PDO::FETCH_ASSOC)) {
- //echo $result;
- }
- $count++;
- $time = microtime_float() - $time_start;
- if ($time > 2) {
- break;
- }
- }
- echo $count . ' заявки към базата за 2 секунди време.<br/>';
- $time_start = microtime_float();
- $count = 0;
- while (true) {
- $file = file("data.txt");
- //echo '<pre>' . print_r($file, true) . '</pre>';
- $count++;
- $time = microtime_float() - $time_start;
- if ($time > 2) {
- break;
- }
- }
- echo $count . ' заявки към файл за 2 секунди време.<br/>';
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement