How to change the Allowed memory size of 134217728 bytes

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