Php reported 404 when he ran the old online data.

in recent days, I have been doing database optimization. Due to the relatively large amount of data, some of the problems encountered are a machine that can put paper towels and count the income of each machine. Now there is a table recording machine information (paper_device) and a machine-related order table (paper_order). Here, there is a new machine details table (paper_device_details) with only two fields in it. Equipment id (device_id) and the amount of income (money) field, but there are more than 80,000 old data online, write an interface, use for cycle to deal with, very slow, there is a long delay in the middle, the data does not seem to be finished, and finally reported 404, asking for advice.

clipboard.png

clipboard.png

clipboard.png

Dec.07,2021

  • paper_device_details

this table can be expanded.

< table > < thead > < tr > < th > total < / th > < th > amount < / th > < / tr > < / thead > < tbody > < tr > < td > Total income < / td > < td > this income < / td > < / tr > < / tbody > < / table >

then the script inserts the total sales of all the machines before using the sum method of SQL to insert the query results. In the future, you can maintain total each time.


clipboard.png

clipboard.png

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bd1996-30d9a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bd1996-30d9a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?