All my current approach is to check the memory, then operation, but often out of memory, don't know how to make everybody is at ordinary times, the amount of data in about 1000 w

CodePudding user response:

Two ideas: 1, if you want to read all the memory and computation, rich, then upgrade the memory! 2, put the query conditions in the SQL statement, returns the calculation results,
Deep understanding of MySQL