Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

How to get more than 100,000 records using PHP and Mysql?

on

I am using Mysql database and having more than 300,000 records in a table. I want all records at once. I don't want pagination. I am getting this error:

Fatal error:  Allowed memory size of 838860800 bytes exhausted (tried to allocate 125435047 bytes) in

In the table there are 20 columns, so the size of the data is huge.

I have used below PHP function:

ini_set('memory_limit', '800M');

How to fix this issue?

Comments

Post a Comment