Laravel Query Builder returning empty rows from 100k+ rows

Question

My users table has over 100K rows. I need to fetch them all for export purpose. But, when I use following code, it doesn't return anything. But, if I apply limit then it returns them. It basically returns 10K rows and when I provide 20K on limit, it doesn't return anything.If I use mysqli_query, it returns all well in the same server and DB.

$myRows = DB::table('users')->get();//returns empty
$myRows = DB::table('users')->take(10000);//returns 10,000 rows
$myRows = DB::table('users')->take(20000);//returns empty

I am new to Laravel. Thanks in advance.

Try this php -d memory_limit=-1 composer update if it's ok with memory — Maraboc
– Maraboc, Commented Aug 10, 2016 at 23:56

Adam Mańkowski · Accepted Answer · 2016-08-10 23:54:04Z

2

I think chunking (scroll to "Chunking Results From A Table" point) would be good option here.

DB::table('users')->chunk(10000, function($users) {
    //some connect code
});

answered Aug 10, 2016 at 23:54

Adam Mańkowski

95812 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel Query Builder returning empty rows from 100k+ rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related