+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: How to change the Allowed memory size of 134217728 bytes (/showthread.php?tid=28634)
How to change the Allowed memory size of 134217728 bytes - El Forum - 03-17-2010
[eluser]Unknown[/eluser]
Hi Guys!
I'm having a trouble in generating a report. I want to generate a report by querying the database. When i made query and returns about 24,000+ of records this error will display in my page "Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 29132801 bytes) in ..system\libraries\Loader.php on line 702"
Is there anyone can help me to solve this problem?
How to change the Allowed memory size of 134217728 bytes - El Forum - 03-17-2010
[eluser]danmontgomery[/eluser]
The solution is to write better queries so you're not getting back 24,000 results... Increasing memory allocation to account for this amount of data isn't a real solution, it's a band-aid, and you're inevitably going to have to do it again (and again).
How to change the Allowed memory size of 134217728 bytes - El Forum - 03-18-2010
[eluser]Unknown[/eluser]
ok..thanks for the reply.. do you have an idea of any better queries for this problem? because my idea is to use pagination so that i can set a LIMIT to my queries..do you have another and better idea for this problem?