Laravel vs PHP query database query execution time

41 Views Asked by At

I have been executing the following query using LARAVEL's ORM Eloquent, "normal" PHP, and also PHPmyuAdmin raw SQLand have surprising execution tilme differences , NOT in favor of LARAVEL, which I find very surprising, so I'm wondering if / what I'm not doing things correctly in LARAVEL

Laravel query :

$words=Word::select('id','mot_origine')->where ('origine','fr')->get();

Execution time : 14.265946865082 sec !!

"Pure PHP" query :

$statement = "SELECT id_mot, mot_origine, genre FROM dico WHERE origine='fr'";
$words = $this->query($statement);

Execution time : 0.25629806518555 sec

PHPMyAdmin Execuction time : 0,0009 second(s).

For a total of 7 803 items ...

0

There are 0 best solutions below