Why in codeignitor 3 mysqli update query taking more then 20 seconds

Asked Dec 16 '22 at 18:41

Active Dec 17 '22 at 06:48

Viewed 32 times

while debugging when I reach on this point it took some time more then minute.

$this->db->where('userid', $userid);
        $this->db->update('tbluser', ['activity' => date('Y-m-d H:i:s')]);

I have executed same update query string in phpmyadmin and it took 0.0005 seconds. Don't know why it is like that, anyone help will be greatly appreciated

edited Dec 17 '22 at 06:48

asked Dec 16 '22 at 18:41

Mohammad Junaid

Please provide the generated SQL. (Codeigniter is one of a hundred frameworks; most of us don't know its details.) – Rick James Dec 18 '22 at 16:57
UPDATE `tbluser` SET `activity` = '2022-11-29 02:06:23' WHERE `tbluser`.`userid` = 27; – Mohammad Junaid Dec 19 '22 at 17:32
The query, by it self, looks OK. Please provide `SHOW CREATE TABLE tbluser`. Also, was a backup (or some other big thing) going on? – Rick James Dec 19 '22 at 17:48

Why in codeignitor 3 mysqli update query taking more then 20 seconds

0 Answers0