Techiio-author
Started by Bruce MccullamSep 30, 2021

Open
Laravel simple query is taking more than 30 seconds on server

1 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 1 VIEWES SHARE

I have a Laravel,Angular,Nginx stack deployed on a server with a really good configuration.

Laravel apis on localhost are really fast but on server some days a simple select query of 10 ids return 504 while same api returns the answer in 200ms on localhost, any idea where should i check or what should i do ?

Optimizing queries will help the speed and i tryed those ways but i feel there's a overhead time delaying api calls on server some days regardless of a simple select query or a complex query.

1 Replies

Techiio-commentatorShuvhojit Deb replied 3 months ago0 likes0 dislikes

After checking everything on Laravel and Mysql and server I found out that the error was being caused by a large associative entity with no index declared for it in Mysql.

You must be Logged in to reply
Trending Technologies
15
Software41
DevOps47
Frontend Development24
Backend Development20
Server Administration17
Linux Administration26
Data Center24
Sentry24
Terraform23
Ansible83
Docker70
Penetration Testing16
Kubernetes21
NGINX20
JenkinsX17
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance