Magento – Fetch Row by Row Like PDO::fetch()

ce-1.9.0.1databaseMySQL

I am running

$connection = Mage::getSingleton('core/resource')->getConnection('core_read');
$sql = "SELECT id FROM customers_old";
$old_customers = $connection->fetchAll($sql);

But it's a HUGH table and this does not fit into memory:

PHP Fatal error: Allowed memory size of 268435456 bytes exhausted

Normally I would make a loop an fetch row by row: $connection->fetch($sql)

But fetch does not exist here and fetchRow() always returns the same row.

Solution?

Best Answer

You'll want to use the core/resource_iterator. This passes each object in a collection through a callback method. This article from Atwix (I'm not connected to them in any way) explains it really well: http://www.atwix.com/magento/working-with-large-collections/.

Related Solutions

PHP MySQL – Fix PDO Exception Error on Index

Just a guess, but it sounds like

Your command line php executable uses a different php.ini file than the web server
The php.ini file your command line version uses has a different, and invalid, value set for the mysql.default_socket ini setting

When you specify a MySQL server host as localhost, you're telling the system to use this socket file to connect to the database server. Check the value when using your local web-server, and make sure that same value is set for the command line program's ini file.

You might also have some luck changing the server to 127.0.0.1 from localhost. (When the system sees an IP address, it knows not to connect via the socket file, but instead to connect via TCP)

Magento 1.7 – Save Two Columns in One Row with setData()

Try this:

Mage::getModel('xmlexport/export_entity')->setData(array('entity_id' => $orderNumber, 'entity_type' => 'order'))->save();

You forgot to wrap your values inside an array.

Here is how Varien_Object::setData() looks like

public function setData($key, $value=null)
{
    $this->_hasDataChanges = true;
    if(is_array($key)) { //if the $key is an array just set that as _data
        $this->_data = $key;  
        $this->_addFullNames(); //do something not important
    } else { //if not array
        $this->_data[$key] = $value; //set data for a specific key
        //do other stuff here
        if (isset($this->_syncFieldsMap[$key])) { 
            $fullFieldName = $this->_syncFieldsMap[$key];
            $this->_data[$fullFieldName] = $value;
        }
    }
    return $this;
}

Best Answer

Related Solutions

PHP MySQL – Fix PDO Exception Error on Index

Magento 1.7 – Save Two Columns in One Row with setData()

Related Topic