A large number of operations database, causing the page to stop running
On the page to do a synchronous data function
There are n databases, all of which have a top-up record table,
Need to synchronize all the top tables on a table in a central database
The database is MySQL
Because the running time is long, the foreground page runs for a period of time and then stops running
What is the solution to the data can be synchronized to the database.
------Solution--------------------
Direct execution of SQL instructions without PHP program intervention
Use PHP to construct SQL commands
------Solution--------------------
The run timeout can be set as follows
Set_time_limit (0);
------Solution--------------------
It is best to directly through the SQL synchronization to the central database, n multi-database, the amount of data is also OK, once the data volume is large, or will encounter this problem ~
