CI框架在CLI下执行占用内存过大问题的解决方法_php实例
很多程序员在使用codeigniter CLI下执行一个大批量数据导入的问题时，会一直出现内存过高的情况，下面对此分析器原因及解决办法。
CI db会将所有的查询sql和和sql执行时间保存下来，对于类似百万级大数据量的导入问题来说，其执行的sql记录都会被保存在内容中，这就占用了大量的内容直至脚本结束。
解决办法：
当你执行大数量的db操作时，记得设置：
$this->db->save_queries = FALSE;
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to use CI framework in php?
Jun 01, 2023 am 08:48 AM
With the development of network technology, PHP has become one of the important tools for Web development. One of the popular PHP frameworks - CodeIgniter (hereinafter referred to as CI) has also received more and more attention and use. Today, we will take a look at how to use the CI framework. 1. Install the CI framework First, we need to download the CI framework and install it. Download the latest version of the CI framework compressed package from CI's official website (https://codeigniter.com/). After the download is complete, unzip
How to debug PHP CLI scripts
May 31, 2024 am 10:44 AM
How to debug PHPCLI script? Use the var_dump() function to display variable contents and types. Set display_errors and log_errors to display errors and log them in the error log. Install and configure Xdebug for advanced debugging capabilities, including stack tracing and variable inspection.
How to use CI framework in PHP
Jun 27, 2023 pm 04:51 PM
PHP is a popular programming language that is widely used in web development. The CI (CodeIgniter) framework is one of the most popular frameworks in PHP. It provides a complete set of ready-made tools and function libraries, as well as some popular design patterns, allowing developers to develop Web applications more efficiently. This article will introduce the basic steps and methods of developing PHP applications using the CI framework. Understand the basic concepts and structures of the CI framework. Before using the CI framework, we need to understand some basic concepts and structures. Down
How to use CI4 framework in php?
Jun 01, 2023 pm 02:40 PM
PHP is a widely used server-side scripting language, and CodeIgniter4 (CI4) is a popular PHP framework that provides a fast and excellent way to build web applications. In this article, we will get you started using the CI4 framework to develop outstanding web applications by walking you through how to use it. 1. Download and install CI4 First, you need to download it from the official website (https://codeigniter.com/downloa
Explore the working principles, similarities and differences between PHP CLI and CGI
Mar 11, 2024 pm 12:39 PM
Working principles and similarities and differences In web development, PHP is a commonly used programming language that can interact with web servers in different ways, the most common of which are through PHPCLI (CommandLineInterface) and PHPCGI (CommonGatewayInterface). This article will explore the working principles, similarities and differences between PHPCLI and CGI, and provide specific code examples to illustrate the differences between them. 1. PHP
A guide to CI frameworks in PHP
May 22, 2023 pm 07:10 PM
With the development of the Internet and its continuous integration into people's lives, the development of network applications has become more and more important. As a well-known programming language, PHP has become one of the preferred languages for developing Internet applications. Developers can use numerous PHP frameworks to simplify the development process, one of the most popular is the CodeIgniter (CI) framework. CI is a powerful PHP web application framework. It has the characteristics of lightweight, easy to use, optimized performance, etc., allowing developers to quickly build
How to introduce css into ci framework
Dec 26, 2023 pm 05:20 PM
The steps to introduce CSS styles in the CI framework are as follows: 1. Prepare CSS files; 2. Store the CSS files in the appropriate location of the CI framework project; 3. In the pages that need to use CSS styles, introduce CSS through the HTML <link> tag File; 4. Use the CSS class or ID name in the HTML element to apply the corresponding style.
In-depth understanding of the similarities, differences, advantages and disadvantages of PHP CLI and CGI
Mar 09, 2024 pm 09:48 PM
PHP is a popular server-side scripting language used for developing dynamic websites and applications. In PHP, there are two main operating modes, namely CLI (CommandLineInterface) and CGI (CommonGatewayInterface). This article will deeply explore the similarities, differences, advantages and disadvantages of PHPCLI and CGI, and illustrate it with specific code examples. First, let's take a look at PHPCLI and CG
