Welcome Guest, Not a member yet? Register   Sign In
How to change the Allowed memory size of 134217728 bytes

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?

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).

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?

Theme © iAndrew 2016 - Forum software by © MyBB