Many programmers always encounter high memory when using codeigniterCLI to execute a large volume of data import. The reasons for this analysis and solutions are as follows.
Many programmers always encounter high memory when using codeigniter CLI to execute a large volume of data import. The reasons for this analysis and solutions are as follows.
Many programmers always encounter high memory when using codeigniter CLI to execute a large volume of data import. The reasons for this analysis and solutions are as follows.
CI db saves all query SQL and SQL Execution time. For import problems similar to millions of large data volumes, the SQL records it executes will be saved in the content ,, this occupies a large amount of content until the script ends.
Solution:
When you perform a large number of db operations, remember to set:
The Code is as follows:
$ This-> db-> save_queries = FALSE;