[FX.php List] Memory Error

[Dale Bengston]

Another way to have this happen is to accidentally retrieve all the records out of a table. If you submit a query to FX that has no search terms, it's like doing a findall. I found this out the hard way on a table with 300K line items.

Dale

On Dec 3, 2009, at 7:18 PM, Karstyn McCoy wrote:

> Thanks Guys.
> 
> I'll do some more debugging to check for endless loops or a
> malfunctioning part of the script.
> 
> Thanks,
> 
> --Karstyn
> 
> 
> 
> On Thu, Dec 3, 2009 at 5:11 PM, Jonathan Schwartz <jschwartz at exit445.com> wrote:
>> Kartsyn,
>> 
>> While you *could* have a script that requires more memory than has been
>> allocated, a more common source of the problem is an endless loop of a
>> script that normally doesn't need extra memory.
>> 
>> Is the problem attributed to just one script?  Is it a new script? Are you
>> doing operations similar to other scripts that have no memory issues?
>> 
>> If the answer to these questions is "Yes", than look for a malfunctionaing
>> script rather than a memory issue.
>> 
>> Hope that helps,
>> 
>> Jonthan
>> 
>> 
>>> Not strictly an FX question but definitly PHP - so thought I try this
>>> list for some good ideas.
>>> 
>>> Here is the issue:
>>> I get a following error when I execute a php script
>>> Fatal error: Allowed memory size of 12582912 bytes exhausted (tried to
>>> allocate 89727 bytes)
>>> 
>>> I have normally fixed this by doing the following
>>> - Increase the memory size in php.ini file
>>> - added a line ini_set('memory_limit', -1)
>>> - restarting the web server and checking phpinfo to validate the change
>>> 
>>> But I still get the error.
>>> 
>>> --Karstyn
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
>> 
>> --
>> Jonathan Schwartz
>> Exit 445 Group
>> jonathan at exit445.com
>> http://www.exit445.com
>> 415-370-5011
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list