Simple SELECT * from ('table_name') fails

My CI application has a simple model method that does a SELECT all from a particular table.

On my development server, where the table contains about 12,000 records, the call to the model method works fine. On my production server, where the table contai开发者_如何学JAVAns about 67,000+ records currently, the call to the model method fails. It just stops execution. Error log doesn't show anything.

It can either be the max_execution time or more likely in this case, it can be the memory_limit. You might be exhausting PHPs memory limit trying to store all those 67K rows in memory.

Max execution time is probably the cause. Increase max_execution_time in your production php.ini file.