Laravel Eloquent ORM maximum rows it could retrieve

Question

I have a table with about 35,000 rows, I want to retrieve it and var_dump all the rows but I could not.

Then I limit the number of rows by 2000, that is alright.

What is the problem, is Laravel Eloquent limiting the number of row each time retrieve or is the hardware problem?

nothing in log, and nothing shows in the browser when i return it. — Kent Liau, Sep 03 '13 at 14:48
the code are simple, i retrieve all using User::all() , which should return me 35000 result — Kent Liau, Sep 03 '13 at 15:04
but when i limit it using User::take(2000)->get() , that is alright. — Kent Liau, Sep 03 '13 at 15:04
Probably a limit on your PHP, have a look in your webserver's error log for exceptions.. — msturdy, Sep 03 '13 at 15:06
actually, i have try it out the maximum rows each time it could retrieve, is about 3000 , or it is depend on the data size — Kent Liau, Sep 03 '13 at 15:06
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/36731/discussion-between-kent-liau-and-msturdy) — Kent Liau, Sep 03 '13 at 15:06

score 1 · Accepted Answer · answered Sep 03 '13 at 15:20

After discussion: You're hitting the memory limit on the server...

The solution is either

the second is more scalable, the question you should ask yourself is

"What happens when I have 1000 times the number of users?"

1 Answers1