getRow($q);
if (\PEAR::isError($data)) {
\ServerLogs::pearErrorLog('copy_translation_usa.php', $data);
echo "Error SQL 1".PHP_EOL;
}
$end = $data->cnt;
$st0 = time();
for($start = 0; $start <= $end; $start += $limit ) {
$st = time();
$q = "DELETE FROM " . TABLE_TO . "
WHERE language = 'usa'
LIMIT $limit;";
$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 "delete 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 );
}