getRow($q);
if (\PEAR::isError($data)) {
\ServerLogs::pearErrorLog('copy_translation_usa.php', $data);
echo "Error SQL 1".PHP_EOL;
}
$start = $data->cnt;
$q = "SELECT COUNT(*) AS cnt
FROM ".TABLE_FROM."
WHERE language = 'usa';";
$data = $dbr->getRow($q);
if (\PEAR::isError($data)) {
\ServerLogs::pearErrorLog('copy_translation_usa.php', $data);
echo "Error SQL 2".PHP_EOL;
}
$end = $data->cnt;
$st0 = time();
for($start; $start <= $end; $start += $limit ) {
$st = time();
$q = "INSERT INTO " . TABLE_TO . "
SELECT *
FROM " . TABLE_FROM . "
WHERE language = 'usa'
ORDER BY iid ASC
LIMIT $limit OFFSET $start;";
$data = $db->query($q);;
if (\PEAR::isError($data)) {
\ServerLogs::pearErrorLog('copy_translation_usa.php', $data);
echo "Error SQL 3".PHP_EOL;
echo "
";
echo "$q";
exit;
}
$ft = time();
echo "insert chunk > '".$start."', exec time(s) = ".round($ft-$st, 2).", exec all time(s) = ".round($ft-$st0, 2).PHP_EOL;
// sleep after execute for sql cluster sync
sleep( $pause );
}