This extension presents some methods for eloquent ORM in order to reduce time and memory consumption.
Sometimes application doesn't need all of eloquent overhead. It just requires to retrieve model's attributes with relations and nothing more.
In this case this methods might be enough useful for you.
- eloquent relations
- illuminate pagination
- PDO::FETCH_OBJ and PDO::FETCH_ASSOC fetch modes
laravel >= 5.3
Run
composer require --prefer-dist volosyuk/simple-eloquent "*"
or add this code line to the require
section of your composer.json
file:
"volosyuk/simple-eloquent": "*"
Just use SimpleEloquent trait in your model. If you want to get models with relations attach SimpleEloquent trait to related models as well.
use Volosyuk\SimpleEloquent\SimpleEloquent;
class Department extends \Illuminate\Database\Eloquent\Model
{
use SimpleEloquent;
}
Then use simple() method in chain of methods calls.
$users = User::whereHas('units')->withCount('units')->with('units')->limit(10)->simple()->get();
$activeUser = User::simple()->where('is_active', 1)->first();
$users = User::with([
'units.leaders.performance',
'teams.leaders.performance',
'programs.courses'
])->limit(50)->get()
Time | Memory consumption | |
---|---|---|
get() | 0.62s | 6.0mb |
simple()->get() | 0.19s | 3.0mb |
$goals = Goal::with('goalUser.user.courses.points.user')->limit(20)->get()
Time | Memory consumption | |
---|---|---|
get() | 1.48s | 28.5mb |
simple()->get() | 0.47s | 15.5mb |
$performance = Performance::whereHas('user')->with('goal.goalUser')->limit(1000)->get()
Time | Memory consumption | |
---|---|---|
get() | 0.22s | 2.0mb |
simple()->get() | 0.06s | 1.1mb |
Since this extension provides less expensive methods you'll definitely lose some functionality. Basic methods return collection of eloquent models in contrast to new functionality which returns collection of stdClasses|arrays. This example will show the difference between results.
$categories = Category::with('articles')->get() // want to grab all categories with articles
Illuminate\Database\Eloquent\Collection::__set_state([
'items' => [
0 => Category::__set_state([
'guarded' => [],
'connection' => 'default',
'table' => NULL,
'primaryKey' => 'id',
'keyType' => 'int',
'incrementing' => true,
'with' => [],
'withCount' => [],
'perPage' => 15,
'exists' => true,
'wasRecentlyCreated' => false,
'attributes' => [
'id' => '1',
'name' => 'Test category',
'created_at' => '2017-12-21 12:33:34',
'updated_at' => '2017-12-21 12:33:34'
],
'original' => [
'id' => '1',
'name' => 'Test category',
'created_at' => '2017-12-21 12:33:34',
'updated_at' => '2017-12-21 12:33:34',
],
'changes' => [],
'casts' => [],
'dates' => [],
'dateFormat' => NULL,
'appends' => [],
'dispatchesEvents' => [],
'observables' => [],
'relations' => [
'articles' => Illuminate\Database\Eloquent\Collection::__set_state([
'items' => [
0 => Article::__set_state([
'guarded' => [],
'connection' => 'default',
'table' => NULL,
'primaryKey' => 'id',
'keyType' => 'int',
'incrementing' => true,
'with' => [],
'withCount' => [],
'perPage' => 15,
'exists' => true,
'wasRecentlyCreated' => false,
'attributes' => [
'id' => '1',
'category_id' => '1',
'title' => 'Test article',
'created_at' => '2017-12-21 12:33:34',
'updated_at' => '2017-12-21 12:33:34',
],
'original' => [
'id' => '1',
'category_id' => '1',
'title' => 'Test article',
'created_at' => '2017-12-21 12:33:34',
'updated_at' => '2017-12-21 12:33:34',
],
'changes' => [],
'casts' => [],
'dates' => [],
'dateFormat' => NULL,
'appends' => [],
'dispatchesEvents' => [],
'observables' => [],
'relations' => [],
'touches' => [],
'timestamps' => true,
'hidden' => [],
'visible' => [],
'fillable' => [],
]),
],
]),
],
'touches' => [],
'timestamps' => true,
'hidden' => [],
'visible' => [],
'fillable' => [],
])
]
]);
Illuminate\Support\Collection::__set_state([
'items' => [
0 => stdClass::__set_state([
'id' => '1',
'name' => 'Test category',
'created_at' => '2017-12-21 12:43:44',
'updated_at' => '2017-12-21 12:43:44',
'articles' => Illuminate\Support\Collection::__set_state([
'items' => [
0 => stdClass::__set_state([
'id' => '1',
'category_id' => '1',
'title' => 'Test article',
'created_at' => '2017-12-21 12:43:44',
'updated_at' => '2017-12-21 12:43:44',
]),
],
]),
]),
]
]);
Since you'll get stdClasses|arrays you won't reach out to casting, appends, guarded/fillable, crud and another possibilities. That's why new methods are much faster ๐