Tag: SELECT count(*)
-
Post Views: 85 1. In the performance environment, the list interface response timeout. as shown in Figure 1 2. Determine the sql of the interface to execute, connect the mysql of the performance environment in the local environment, and then view the generated sql in Laravel Telescope, and find a select count(*) as aggregate FROM is much longer than other…
-
Post Views: 19 1. Adding fields to a table takes 180 seconds. as shown in Figure 1 2. The total number of records in the query table is: 173816. as shown in Figure 2 3. Decide to allow the newly added field to be null, and add the field again, which takes 104 seconds. as shown in Figure 3 4.…