To insert multiple records inside foreach loop we have two options:
foreach($result as $data): $_model=>Mage::getModel(''); $_model->setField1() $_model->setField2() $_model->setField3() $_model->setField4() $_model->save() endif;
direct SQL query in foreach loop.
Unfortunately both are time consuming process if the loop executes for 10-30 times.
Anyone have any idea as how to make this process faster.