laravel MySQL query optimization

Question

I have the following sql queries in my application.

$defaultGoal = DB::table("goals")
-> where("activitiesID", "=", $this->activityID)
-> where("usersID", "=", $userID)
-> pluck("goal");

$defaultGoalPoints = DB::table("goals")
-> where("activitiesID", "=", $this->activityID)
-> where("usersID", "=", $userID)
-> pluck("goalpoints");

$defaultPoints = DB::table("goals")
-> where("activitiesID", "=", $this->activityID)
-> where("usersID", "=", $userID)
-> pluck("points");

Each query returns an array. Is there a way to do combine all of these queries into one, that will return the same arrays for $defaultPoints, $defaultGoalPoints, and $defaultGoal.

If the goal is to reduce the number of queries you're writing, what about simply using ->get() to retrieve the entire entries and then using php to pull the data you want into arrays? (Laravel may have a shorter way to do this though, and I'll let someone else speak up if they know of it.) — Atlas
– Atlas, Commented Apr 14, 2016 at 19:05

Laerte · Accepted Answer · 2016-04-14 19:07:48Z

1

You can use select to get only what you need:

$defaults = DB::table("goals")
->select('goal', 'goalpoints', 'points')
->where("activitiesID", "=", $this->activityID)
->where("usersID", "=", $userID)
->get();

Hope it helps...

answered Apr 14, 2016 at 19:07

Laerte

7,0833 gold badges35 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

laravel MySQL query optimization

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