in my laravel site with breeze, when i try to open page, it very very slow. The query is "select * from users where id = 1 limit 1" take 4 seconds. Why? Can help me? Thanks a lot.
Laravel 9.1, Breeze
Asked
Active
Viewed 154 times
0
-
How many records does your table have? If it has records in thousand then it is normal to take few seconds. – Muhammad Yasir Jun 10 '22 at 10:36
-
I have 3 records – Bonci Marco Jun 10 '22 at 10:40
-
Are you using eloquent? – Muhammad Yasir Jun 10 '22 at 10:41
-
If yes then can you post your eloquent query here? – Muhammad Yasir Jun 10 '22 at 10:41
-
I think yes! This table created after install breeze in my laravel project – Bonci Marco Jun 10 '22 at 10:42
-
public function retrieveById($identifier) { $model = $this->createModel(); return $this->newModelQuery($model) ->where($model->getAuthIdentifierName(), $identifier) ->first(); } – Bonci Marco Jun 10 '22 at 10:45
-
I don't change anythink, this is breeze standard installation.... – Bonci Marco Jun 10 '22 at 10:47
-
Probably this has nothing to do with the framework, but with your mysql server. Have you tried to run that command in your mysql client? Here you are how can you test what I´m talking about. https://fedingo.com/how-to-get-query-execution-time-in-mysql/ – Manuel Glez Jun 10 '22 at 17:00
-
Hi, my profiles is 1 | 0.00051821 | select * from users where id = 1 limit 1. This is in the server...in my laravel with breeze 4.2seconds....i don't know why...it absurd....any ideas? – Bonci Marco Jun 13 '22 at 17:31