Solve the problem that the CI framework occupies too much memory in CLI. 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 in CIdb always encounter high memory usage 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 timeFor the import problem similar to millions of large data volumes, the SQL records executed by the system will be stored in the content, which 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;
When a large volume of data is imported under the consumer CLI, the memory usage is too high. The reasons for this analysis and solutions are as follows. CI db will...