Skip to main content
Category:

DB Raw Query Calculations Run Faster in Laravel


Use SQL raw queries like whereRaw() method, to make some DB-specific calculations directly in query, and not in Laravel, usually the result will be faster. Like,
if you want to get users that were active 30+ days after their registration, here's the code.


User::where('active', 1)->whereRaw('TIMESTAMPDIFF(DAY, created_at, updated_at) > ?', 30)->get();

Riadh Rahmi

Senior Web Developer PHP/Drupal & Laravel

I am a senior web developer, I have experience in planning and developing large scale dynamic web solutions especially in Drupal & Laravel.

Web Posts

Search

Page Facebook