How to add, modify and delete multiple data by php+mysqli preprocessing technology

This article mainly shows you the "php+mysqli preprocessing technology how to add, modify and delete multiple data", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "php+mysqli preprocessing technology how to add, modify and delete multiple data" this article.

The specific analysis is as follows:

First of all, why is there a preprocessing (precompilation) technology? For example: suppose you want to add 100 users to the database, which, in the usual way, sends 100 execution requests to the database. At this point, according to how the mysql database works, it needs to compile each execution statement (100 times here). Therefore, the efficiency here is very low.

The function of preprocessing (precompilation) technology is to reduce the number and time of compilation in order to improve the effect. Through a case to illustrate how preprocessing (precompilation) technology is done (well, to be clear, when the php program sends sql statements for the first time, the mysql database is compiled, to the next 99 times, php just sends the data over, no more compilation is needed).