PHP Performance (memory) related issues

PHP Performance (memory) issues
Author: zccst

Encounter such a problem

$RETARR = Array (); Order of magnitude: 10/Hundred

One of the fields is a model, an array of eligible models
$MODELARR = Array (); Order of magnitude: thousand

One of the fields is SN, the SN array of the complex condition
$SNARR = Array (); Order of magnitude: 100,000 articles


Test instructions: There is SN information in the $MODELARR, but to determine if the SN is in $snarr, if it is, the compound condition is indicated, if it does not indicate a non-conforming condition (such as not on the line).

Issue: 100,000 *1000*100 = 10 billion of data, resulting in insufficient memory.


Solution 1: Use In_array ($key, $DESTARR);

The actual run found insufficient memory.


Workaround 2: Combine SQL queries.

Possible, but it will take 1-2 minutes to run. The default timeout for front-end ExtJS is 30 seconds, so changing the default time-out to 5 minutes resolves the problem.

