Welcome Guest, Not a member yet? Register   Sign In
Inserting For each?
#16

[eluser]CroNiX[/eluser]
look into a batch insert. Inserting in a loop is very resource consuming compared to a single query.

Code:
foreach ( $aanwezigheid as $llID => $aanwezig )
{
   $data[] = array(
    'llID'     => $llID,
    'lesuurID' => $lesuur,
    'aanwezig' => $aanwezigheid
   );
}
$this->aanwezigheid_model->updateAanwezigheid($data);
Code:
aanwezigheid_model::updateAanwezigheid($data)
{
  return $this->db->insert_batch($data);
}


Messages In This Thread
Inserting For each? - by El Forum - 06-11-2012, 07:15 AM
Inserting For each? - by El Forum - 06-11-2012, 10:18 AM
Inserting For each? - by El Forum - 06-11-2012, 10:35 AM
Inserting For each? - by El Forum - 06-11-2012, 10:40 AM
Inserting For each? - by El Forum - 06-11-2012, 10:49 AM
Inserting For each? - by El Forum - 06-11-2012, 10:58 AM
Inserting For each? - by El Forum - 06-11-2012, 11:03 AM
Inserting For each? - by El Forum - 06-11-2012, 11:07 AM
Inserting For each? - by El Forum - 06-11-2012, 12:08 PM
Inserting For each? - by El Forum - 06-11-2012, 12:14 PM
Inserting For each? - by El Forum - 06-11-2012, 12:42 PM
Inserting For each? - by El Forum - 06-11-2012, 01:03 PM
Inserting For each? - by El Forum - 06-11-2012, 01:24 PM
Inserting For each? - by El Forum - 06-11-2012, 01:31 PM
Inserting For each? - by El Forum - 06-11-2012, 02:06 PM
Inserting For each? - by El Forum - 06-11-2012, 02:45 PM
Inserting For each? - by El Forum - 06-11-2012, 03:46 PM



Theme © iAndrew 2016 - Forum software by © MyBB