[eluser]comex[/eluser]
Hello,
I'm getting very poor performance when a transaction "fails".
Code:
$this->db->trans_start(TRUE);
[Loop through received data and send it to a model that deals with the inserts/updates.]
$this->db->trans_complete();
if ($this->db->trans_status() === FALSE)
{
[Return error]
}
When the transaction finishes without any error it finishes very quickly, but when an error occurs it seems to stall for 3-4 seconds before rolling back.
Is this due to the fact that I call an external model for the database interaction? (The model uses active record)
I've disabled db_debug in the database.php config file as was suggested somewhere else...
Thank you