*/
$resource = Mage::getSingleton('core/resource');
/**
* Retrieve the read connection
*/
$readConnection = $resource->getConnection('core_read');
// 1. query to order by session_expires, limit N, save last expire time, and session_id
// 2. modify query with where session_expires >= last expire time, and session_id != session_id
$exptime = 0;
$lastid = 'NONE';
$batchlimit = 100;
do {
//$query = 'SELECT session_id, session_expires, session_data FROM ' . $resource->getTableName('core/session').
// ' WHERE session_expires >= ? AND session_id != ? ORDER BY session_expires ASC LIMIT '.$batchlimit;
//$results = $readConnection->fetchAll($query, array($exptime, $lastid));
$query = $readConnection->select()->from(array('cs' => $resource->getTableName('core/session')), array('session_id', 'session_expires', 'session_data'))->having("session_expires > ?", $exptime)->having("session_id != ?", $lastid)->limit($batchlimit)->order('session_expires');
$results = $readConnection->fetchAll($query);
//var_dump($results);
foreach ($results as $row) {
$lastid = $row['session_id'];
$exptime = $row['session_expires'];
$sesskey = PREFIX . $lastid;
$_redis->set($sesskey, $row['session_data']);
$_redis->expireat($sesskey, $exptime);
echo $lastid . " " . $exptime . "\n";
}
echo "----------------------------------\n";
} while (!empty($results));
/*
Zend_Debug::dump($_SESSION);
*/
