阵列占用了太多内存 - Array taking up waay too much memory

Array taking up waay too much memory

本文关键字：太多内存阵列 | 更新日期: 2023-09-27

我正在创建一个数组来保存从查询返回的值 - 似乎添加到多维数组会导致脚本占用多达 125Mb 的内存，并且考虑到数组应该容纳的数据总量不超过 5Mb，这很奇怪：

这是我正在做的事情：

try 
{
    if (!$link = mysql_connect(DB_Host, DB_User, DB_Password))
            Throw New Exception(mysql_error());
    if (!mysql_select_db("Spexplus_Demo"))
            throw New Exception(mysql_error());
} 
catch (Exception $e) 
{
    echo $e->getMessage().$e->getTraceAsString();
    exit(1);
}
$query = "select cda.categoryid as categoryId, 
                  cda.templatetype as templateType, 
                  hn.headerid as headerId, 
                  hn.name as headerName, 
                  an.attributeid as attributeId, 
                  an.name as attributeName
                  from categorydisplayattributes cda 
                  join categoryheader ch on cda.headerid = ch.headerid 
                  and cda.templatetype = ch.templatetype 
                  and cda.categoryid = ch.categoryid 
                  join headernames hn on cda.headerid = hn.headerid 
                  and hn.localeid = 1
                  join attributenames an on cda.attributeid = an.attributeid 
                  and an.localeid = 1";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
        {
            $categorydisplayattributes[$row['categoryId']][$row['templateType']][$row['headerId']][$row['headerName']][$row['attributeId']][$row['attributeName']] =array() ;
        }

echo "Memory After CDA:".memory_get_usage(TRUE).Line_Terminator;
exit();

当我检查时，查询结果本身不会超过 5Mb 左右，但是，以这种方式将值分配给数组会导致峰值 - 还有其他人遇到过这样的事情吗？

    while($row = mysql_fetch_assoc($result))

           {
//concatenate the values using '.' if string 
$index = $row['categoryId']][$row['templateType']][$row['headerId']][$row['headerName']][$row['attributeId']][$row['attributeName'];
                $categorydisplayattributes[$index] =array() ;
            }

试试看。