I'm using codeigniter
now my ajax request its very slow and I want to find the reason
in ajax request, I want to save all DB query in a log file
it's possible?
I'm using codeigniter
now my ajax request its very slow and I want to find the reason
in ajax request, I want to save all DB query in a log file
it's possible?
you can turn on db loging in config file:
$db['default'] = array(
...
'save_queries' => TRUE
....
);
then end of ajax request use $queries = $this->db->queries;
to get all SQL query
$log .= join("
",$this->db->queries);
$myfile = file_put_contents('logs.txt', $txt.PHP_EOL , FILE_APPEND | LOCK_EX);