Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE user_value
(`user_name` varchar(4), `user_pass` varchar(3))
;
<?php
// Создаем таблицы
$pdo->exec("CREATE TABLE test_int (id INT PRIMARY KEY, name VARCHAR(255))");
$pdo->exec("CREATE TABLE test_bigint (id BIGINT PRIMARY KEY, name VARCHAR(255))");
// Вставляем данные
$startTimeInt = microtime(true);
for ($i = 0; $i < 10000; $i++) {
$stmt = $pdo->prepare("INSERT INTO test_int (id, name) VALUES (?, ?)");
$stmt->execute([$i, "Name $i"]);
}
$endTimeInt = microtime(true);
$startTimeBigint = microtime(true);
for ($i = 0; $i < 10000; $i++) {
$stmt = $pdo->prepare("INSERT INTO test_bigint (id, name) VALUES (?, ?)");
$stmt->execute([$i, "Name $i"]];
}
$endTimeBigint = microtime(true);
// Выводим результаты
echo "Time for INT: " . ($endTimeInt - $startTimeInt) . " seconds\n";
echo "Time for BIGINT: " . ($endTimeBigint - $startTimeBigint) . " seconds\n";
// Удаляем таблицы
$pdo->exec("DROP TABLE test_int");
$pdo->exec("DROP TABLE test_bigint");