Allowed memory size of 134217728 bytes exhausted (tried to allocate 42 bytes) [closed]

Question

I am retrieving record from mysql table which return more than 0.2m number of rows per query, which obviously take lot of memory. in my case i have 8 GBs installed RAM on my system with SSD 256 GBs. When i execute my page it returns the following error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 42 bytes) in D:\xampp\htdocs\classes\CRUD.php on line 84   

I think i should need to use threading instead of php loops over table rows? Maybe i am wrong. Any suggestion/help will be appreciated.

Answer 1

Default php.ini memory_limit is 128 MB. You should either:

• Optimize your code to use a normal amount of data
• change memory_limit in php.ini to higher value which I do not recommend at all - with your approach you will hit this wall once again