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
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.