php tp3.2 脚本大量数据操作思路

public function update_point(){
        ini_set('memory_limit','3072M');    // 临时设置最大内存占用为3G
        set_time_limit(0);   // 设置脚本最大执行时间 为0 永不过期
        $pageSize = 1000;
        $i = 0;
        $j = 0;
        $t = 0;
        for ($x = 1; $x >= 0; $x++) {
            $payok = M('pay_ok', 'cy_')
                ->field(['id', 'amount','gameid', 'regagent'])
                ->page($x, $pageSize)
                ->select();
            $total = count($payok);
            $t +=$total;
            if ($total == 0) break;

            foreach ($payok as $one) {
                $gameid = $one['gameid'];
                $regagent = $one['regagent'];
                if (!empty($gameid) && !empty($regagent)) {
                    $point = getAgentPoint($gameid, $regagent);
                    M('pay_ok', 'cy_')->where(['id' => $one['id']])->save([
                        'point' => $point,
                        'agent_amount' => ($one['amount'] * $point / 100),
                    ]);
                    $i++;
                } else {
                    $j++;
                }
            }

            // 停留500毫秒
            usleep(500);
        }

        echo "总数：".$t."<br>";
        echo "更新成功数：".$i."<br>";
        echo "不用更新的数：".$j."<br>";
    }

public function gift(){
        set_time_limit(0);
        $sql = "select a.*,b.key from cy_ct_game_gift_package a left join cy_ct_game_gift_key b on a.id=b.gift_id where a.game_id=180 and a.status=1 and type=0 group by a.id,b.key";
        $res = M()->query($sql);
//        print_r($res);
//        exit;
        foreach($res as $one){
            $key = $one['key'];
            $id = $one['id'];
            unset($one['key']);
            unset($one['id']);

            if(!empty($key)){
                //1. 生成一个公会礼包
                $one['type'] = 1;
                M('game_gift_package','cy_ct_')->add($one);

                $newId = M()->getLastInsID();

                //2. 公会礼包生成9999个礼包key
                $data = [];
                $max = 9999;
                for($i=0;$i<$max;$i++){
                    $d['gift_id'] = $newId;
                    $d['key'] = $key;
                    $data[] = $d;
                }

                $arr = array_chunk($data,5000);
                foreach($arr as $chunkArr){
                    M('game_gift_key','cy_ct_')->addAll($chunkArr);
                    sleep(1);
                }


                //3. 一般礼包也生成9999个礼包key
                $data = [];
                $max = 9999;
                for($i=0;$i<$max;$i++){
                    $d['gift_id'] = $id;
                    $d['key'] = $key;
                    $data[] = $d;
                }
                $arr = array_chunk($data,5000);
                foreach($arr as $chunkArr){
                    M('game_gift_key','cy_ct_')->addAll($chunkArr);
                    sleep(1);
                }

            }
        }
    }