Database/MySQL
MySQL DATE_ADD() vs php strtotime()
4번독수리
2016. 9. 21. 10:54
$l = 100;
// DATE_ADD() : 0 sec
$sql1 = "select * from TABLE where Date > DATE_ADD(NOW() INTERVAL -30 DAY)";
$starttime = time();
for ($i = 0; $i < $l; $i++) {
mysql_query($sql1);
}
$endtime = time();
echo $endtime - $starttime, "\n";
// strtotime() : 7 sec
$date = date('Y-m-d H:i:s', strtotime('-30 days'));
$sql2 = "select * from TABLE where Date > '{$date}'";
$starttime = time();
for ($i = 0; $i < $l; $i++) {
mysql_query($sql2);
}
$endtime = time();
echo $endtime - $starttime, "\n";