Re: Multiple Inserts without a loop

I've just made some test populating a database with millions of rows and the difference between ->save() and ->saveMany() wasn't very important (~100 query/seconds vs ~125 q/sec) (on a old local server).

But then I've made it work throught $this->MyModel->getDataSource()->insertMulti('MyModel', $fields, $values) and the difference is so HUGE ! I've been able to pass ~2000 q/sec continuously and my code wasn't optimized.

The fact is, parsing the data to go from a standard $dataToSave: array( 'MyModel' => array('data1' ...) ) to a $query compatible with insertMulti is just a breeze. Why not use this method with the ->saveMany() ? It's just way more efficient data processing.

Thanks anyhow for the info, saved me probably a month of passive computing ^^

Le mardi 30 septembre 2008 13:12:22 UTC+2, JadB a écrit :

DboMysql::insertMulti will return an SQL query similar to the one you
are looking to get: INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),
(7,8,9);

You could add this new method to app_controller.php if you want:

function multiSave(&$model, $values, $fields = null)
{
   $this->db =& $model->getDataSource();
   $this->db->insertMulti($model->table, $fields, $values);
}

Pass to it something like:

$values = array('(1, 2, 3)', '(4, 5, 6)', '(7, 8, 9)');
$fields = array('a','b','c');

I might be wrong, but this works for me so far and isn't really any
kind of 'hack', it's just using what's there in the framework. Hope it
helps!

JadB
http://loudbaking.myeasyscripts.com

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.