Year: 2024
-
Post Views: 17 1. The front-end response timeout, the response time is: 1 m 0.06 s. as shown in Figure 1 2. The response of the back-end interface does not time out, and the response time is: 1 m 5.70 s. as shown in Figure 2 3. Adjust the proxy settings and add 3 timeout-related settings. The default is 60s,…
-
Post Views: 17 1. Reference: In mysql 8.0, when the total number of table records is checked, the analysis and optimization of the timeout is optimized. Add WHERE ID > 0 when a COUNT SQL does not exist where condition exists. 2. Reference:How to check if table is already has a where Clause in Laravel Query Builder? The final implementation…
-
Post Views: 24 1. An interface request response timeout, because count(*) SQL takes 54 seconds. The amount of data in the table exceeds 10 million. as shown in Figure 1 2. The table field Shipping_Type has an index to add, and its value is only 1 and 2 possibilities. Decide to add the where condition Shipping_Type in (1,2). The query…
-
Post Views: 16 1. When pulling in TortoiseGit, an error is reported: Error: Some local refs could not be updated; try runningGit Remote Prune OriginTo remove any old, conflicting branches. as shown in Figure 1 2. Check the prompt information carefully and find that there is: error: cannot lock refrefs/remotes/origin/sc/fix/to-be-merged-table-scroller:refs/remotes/origin/sc/fixexists; cannot createrefs/remotes/origin/sc/fix/to-be-merged-table-scroller. as shown in Figure 2 3. Reference: When…
-
Post Views: 15 1. The request parameters are as follows, you need to ensure the uniqueness of logistics_freight_no in the table. Since batch overriding writes are supported, the final implementation is to clear all records of RETURN_ORDER_ID of 28, and then rewrite them all. 2. The verification rules are implemented as follows 3. When there is a duplicate value in…
-
Post Views: 17 1. The implementation at this stage is as follows. The final generated SQL will always need to be associated with several other tables, otherwise an error will be reported. 2. The adjusted implementation is as follows. After preparing new request($criteria), then judge whether to join, and the generated sql is associated with other tables on demand, which…
-
Post Views: 17 1. In Laravel 9, an error is reported: call to undefined method illuminate\\http\\resources\\missingValue::isempty(). as shown in Figure 1 2. Check the code implementation 3. Print $this->whenloaded(Customtagsenable), the result is as follows, which are the results of the resource after the model association is not loaded, and the resource after the model association is loaded 4. Re-implement the…
-
Post Views: 20 1. When there are multiple rows of data in the table, the implementation is as follows. Error: call to a member function value() on null. as shown in Figure 1 2. The adjustment is realized as follows. When the record does not exist, the query result is NULL. When the record exists, the query result is int(6),…
-
Post Views: 18 1. Job runs an error in Laravel 9: Has Been Attempted too many times or run too long. The job may have previously previously timed out.. as shown in Figure 1 2. The total number of records found in the table is 8761297. Based on the chunk method, the entire table is retrieved in units of 10…
-
Post Views: 23 1. Try to pass multiple fields/values based on the Redis facade Hset, the code is implemented as follows 2. Error during operation: local.error: err wrong number of arguments forhsetcommand. as shown in Figure 1 3. However, starting from Redis 4.0, HSET can set one or more field/value pairs at a time. Since Redis 4.0.0, HMSET is discarded,…