devamit2018's avatar

load large data in ubuntu

i have a project in laravel and deployed in ubuntu virtualbox.but it gives error when loading the controller having records 90k.after keeping limit it works fine..need suggestions to resolve it..i have kept manual laravel pagination

0 likes
5 replies
fabricecw's avatar

What type of error do you receive? Gateway timeout?

ritey's avatar

Are you loading the model data without any manipulation in the control, or are you getting the data and then trying to manipulate it which is causing the timeout?

Also, are you doing joins etc or a straight table read?

devamit2018's avatar

192.168.2.128 is currently unable to handle this request. HTTP ERROR 500 and then it says Allowed memory size of 134217728 bytes exhausted (tried to allocate 4194312 bytes)

fabricecw's avatar

What is the PHP memory limit according to phpinfo()?

Please or to participate in this conversation.