Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 64 b

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 64 bytes) in D:\wamp\www\stjude\system\database\DB_result.php on line 295.
I got this error when run my application. i have more data in my database.

how to retrieve the data from database using model. I use foreach loop more and more function.
i used more regular queries

for eg:
$query = $this->db->query('YOUR QUERY HERE');


Thnaks for advance and quick reply...

Its very urgent

Increase the maximum allowed memory for each PHP script either by configuration (memory_limit directive in your php.ini file)
or in execution time by using ini_set('memory_limit', '200M');

Also you can limit the amount of data from your database using the limit statement.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

You should optimize your query. for example, don't select all columns, but only select the once with the data you need.

Thanks to InsiteFX and Diederik .

Now working..

Now I am optimize the my query as you told to me