Database
Eloquent
Laravel
moderator
Hello @abduruntime ,
For the amount of 20 0000 rows it is a good option to use a chunk or cursor, the best option depends on your query.
To be honest a join is most of the time very inefficient and it can be advisable to see if you can rewrite it to a query that doesn't use joins.
The part about Eloquent, Query Builder or raw is also the order that I advice :)
If possible without problems: Use Eloquent. Else try the Query Builder. If both is not an option then you need to go to a raw query.
What I see in my projects is most of the times a mix from Eloquent and the query builder.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast