How to change the Allowed memory size of 134217728 bytes

[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?

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

[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?