Fatal error: Allowed memory size of xxxbytes exhausted

This is what the Pagination Library is used for to limit the number of records retrieved.

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

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

This is what the Pagination Library is used for to limit the number of records retrieved.

As per pagination library I have to give "total_rows",  For the total count  my  query is getting exhausted .

Code:

$this->load->library('pagination');

$config['base_url'] = 'http://example.com/index.php/test/page/';
$config['total_rows'] = 200; [ I am getting error here , counting 300K-500K records creating memory out problem ]
$config['per_page'] = 20;

$this->pagination->initialize($config);

echo $this->pagination->create_links();

 Any way thanks. Now I am considering changing DB structure to divide tables. Let's see.

Code:

$this->load->library('pagination');

$config['base_url'] = 'http://example.com/index.php/test/page/';
$config['total_rows'] = 200; [ I am getting error here , counting 300K-500K records creating memory out problem ]

Huh? How do count your rows? Don't you know about "select count(*)" ? How can it use so much memories if it returns a single number?

Code:

$this->load->library('pagination');

$config['base_url'] = 'http://example.com/index.php/test/page/';
$config['total_rows'] = 200; [ I am getting error here , counting 300K-500K records creating memory out problem ]

Huh? How do count your rows? Don't you know about "select count(*)" ? How can it use so much memories if it returns a single number?

Hi, I am using $this->db->count _all() . From your reply tone  I think , I am doing some mistake. Let me check once again the complete code so that I can reply in details. Thanks

Huh? How do count your rows? Don't you know about "select count(*)" ? How can it use so much memories if it returns a single number?

Hi, I am using $this->db->count _all() . From your reply tone  I think , I am doing some mistake. Let me check once again the complete code so that I can reply in details. Thanks

That's weird because count_all() do a "select count(*)", it doesn't fetch all the data. So I don't understand why you would run out of memory!