For API requests, TTFB takes a long time and is unstable, ranging from more than 400ms to tens of seconds.

clipboard.png

the environment is iis+mysql, backend language php, daemon execution time is basically about 200ms, when the TTFB is longer, this value is correspondingly longer.

question: does the program of
1.200ms take a long time to execute?
2. Why is the processing time particularly long in some cases, is the network unstable?
3. How to optimize TTFB in this case?

Sep.27,2021

1. 200ms is normal for php, but don't use IIS if you want to optimize it. Nginx+php-fpm learn about
2. There are many reasons why the processing time is very long, including the client, the server, and the network is also a
3. First of all, we need to find out whether the problem is in the front end, the back end, or the network

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1ede14f-399e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1ede14f-399e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?