Laravel Eloquent performance issue

Question

when I use Eloquent to get data, and found out some performance issue

In my case, I use laravel debugbar ( https://github.com/barryvdh/laravel-debugbar ) to collect the information I need.

when I use ORM to get about 20 entries from my DB

$projects = Project::where('status', '=', 2)->get();

it took about 24MB memory usage and 250ms

but when I use the query builder as below

$projects = DB::table('Project')->where('status','=',2)->get();

the database queries and the return data are almost the same, but query builder took only 11MB memory usage and 113ms to get the data.

when the entries I need are about 200 entries, and even relate to other tables via ORM, it take almost 8000ms... and get the "Allowed memory size exhausted" error message very often..

So, I was wondering, in my condition, should I use the query builder and join other table?

Or what should I do to speed up the Eloquent performance ?

Eugene Wang · Accepted Answer · 2013-11-25 03:17:17Z

3

Finally I found out where the problem is. Actually, that issue is not really caused by Eloquent ORM but the view. That are what I did for fixed the problem

Eager loading: Since there are 4 relations in my view, so it cause N + 4 queries , I use the eager loading to fixed it. and use
Cache: I use remember() to cache results.
Cancel the Image checking: last things I did but most important, is to cancel the checking the Images in S3.

The page loading get a huge speed up. :)

answered Nov 25, 2013 at 3:17

Eugene Wang

4691 gold badge5 silver badges11 bronze badges

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

Comments

egig · Accepted Answer · 2013-11-21 10:07:24Z

2

Just an idea, you probably need to disable query logging:

DB::connection()->disableQueryLog()

and use caching: http://four.laravel.com/docs/cache ,

if no significant difference then yes, you pobably just need to use query builder or even the basic:

DB::select(//your query here...)

edited Nov 21, 2013 at 10:07

answered Nov 21, 2013 at 9:49

egig

4,4405 gold badges31 silver badges50 bronze badges

Collectives™ on Stack Overflow

Laravel Eloquent performance issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related