How to solve the problem of 504 caused by too long response time? - Codes Helper - Programming Question Answer

How to solve the problem of 504 caused by too long response time?

I am maintaining an older system. One of the requirements of struts2 + hibernate, is to find the data according to the request of the front end and then download the Excel file. If the request field is empty, then download all the data for today. Usually, there are no more than 3000 data in a day.

there is nothing wrong with the old system doing this. After I take over this project, I want to modify one place, that is, when I download, I have to download the two locations corresponding to each piece of data queried. These two location information is not in the database. One location needs to request a third-party interface, and one location requests another system of our company.

my method is also simple and rough, that is, after I find out, I go through it again, and each record requests location information twice. There is no problem with hundreds of pieces of data, but there is a 504 error when downloading more than 2000 pieces of data.

I can"t think of anything for the time being. I"m here to consult you. Thank you!

Javascript java

Sep.08,2021

emmm, can change the way of thinking. Refer to one of my previous answers to see if it suits you

.

https://codeshelper.com/q/10.

however, you can consider the way of changing space for time. If the location information corresponds to your data is unchanged, you can consider caching them in your database, doing a scheduled task, running in the middle of the night every day, caching the location information corresponding to the data you are going to download today to your local location, so that it may be much faster when downloading files at that time. And then using the asynchronous method mentioned in my question, sending it by e-mail, it should be able to completely solve your problem, and there will be no 504

.

can the location information be redundant into the corresponding data?

Previous: The anti-climbing of climbing the hook net.

Next: Android passes an image path to H5, how to get a file file or base64? through JS processing

Ios native call js, what is the global scope of js?
1. If I call the function of js natively, I am not sure what the scope of the function of js is. I packaged the node module with bowseriry and wanted to expose the function I wrote to the native call . For example, the global domain of window,node in the...

Objective-c javascript javascriptcore

Feb.27,2021
The .log file could not be found
Import project prompt error: log4j:ERROR setFile (null,true) call failed. java.io.FileNotFoundException: d:classnet.log (the system cannot find the specified path.) ask for the guidance of the gods! ^ _ ^ ...

Struts spring eclipse javascript java

Feb.27,2021
JSON and parsing problems
the logic for the background to return the json result is Map<String, Object> resultMap = new HashMap<>(); resultMap.put("userType", userType); resultMap.put("phone", phone); resultMap.put("channel&q...

Json jquery javascript java

Feb.28,2021
Ajax requests backend, and the backend returns binary data. How should JS be parsed?
background code snippet: UtilHttp.streamContentToBrowser(response, UtilObject.getBytes(list), "application octet-stream"); background list: listbyte[],ioJSAjax: dataType: "text ": ... XMLHttpRequest byteArray: list ...

Javascript java html5 html node.js

Feb.28,2021
There is a problem with the configuration of AES encryption settings. The encrypted format is uppercase and lowercase letters, percent sign, no equal sign, no good communication,% from encodeURI, final.
package cn.chinaunicom.changyue.util; import javax.crypto.Cipher; import javax.crypto.spec.IvParameterSpec; import javax.crypto.spec.SecretKeySpec; import org.apache.commons.lang.StringUtils; ** * : AES<br > * : AES<br > * : <br ...

Aes encrypted javascript java

Feb.28,2021
WeChat Mini Programs, why did you report this mistake?
...

Html javascript java

Mar.01,2021
In js, why does the ternary operator only show "new rent" instead of "new group wealth building" when the ternary operator is established?
$("-sharpcontract_remark").text( data.data.type==0 ? "" : ""+""+data.data.rentRooms.name +""+data.data.area+"");...

Javascript java

Mar.01,2021
WeChat Mini Programs, why, after Wechat authorized to click permission, why can not directly get the avatar information, but also need to click again?
...

Css html javascript java

Mar.01,2021
How can the front end appear "system maintenance page" in time when the front end is separated, the back end is maintained or when something goes wrong?
RT backend java frontend Vue ...

Javascript java

Mar.02,2021
Using ajax for form submission, developer tools can see what to do with the data
I want to use ajax to submit the form, verify that the user name password is correct, and use json to transfer data, which is also a post submission method, but once submitted, I find that the user name and password can be seen on the developer s tool. ...

Javascript java

Mar.02,2021
WeChat Mini Programs, how to set up a pop-up input box after clicking the "reject" button, you can enter the reason?
now the pop-up can only be confirmed twice, and you can t enter the content? I want to click "disagree " and pop up an input box to fill in the reason for disagreement. ...

Javascript java

Mar.02,2021
How to know which radio button input? is selected
as shown in the figure, there are two input tabs, which are two radio buttons. Choose to turn them on or off. After clicking Save Settings, a div on the page will be shown or hidden. my problem is, when I click Save Settings, how do I know if I cli...

Vue.js javascript java html

Mar.03,2021
Cross-domain front and back end setting withCredentials:true is still unable to carry cookie problem
this is the code of the front-end request javacors is there something wrong with the setting mode? I don t know much about the background code at the front end, and I don t know how to solve cross-domain problems in the background . ...

Javascript java

Mar.03,2021
What is the current mainstream and reliable login password encryption process?
how reliable is the process of password authentication for user login? (do not discuss channel encryption on https) 1. The front-end plaintext passes the password to the back-end for encryption, and compares the processed ciphertext with the database t...

Javascript java security-protection cryptography password-protection

Mar.04,2021
Authorization of Mini Program's third-party platform
the company has developed a third-party platform for Mini Program. In the case of not being released throughout the network, obviously the operation steps are the same. Why can t the second Mini Program account generate Mini Program? some have trie...

Javascript java Mini-Program

Mar.04,2021
The problem of converting a specific format string to json format in JS
A string is as follows: Table name 1 @ Field 1 ~ Table name 1 @ Field 2 ~ Table name 2 @ Field 1 ~ Table name 2 @ Field 2 how to reasonably handle it in json format { 1:[12], 2:[1, 2] } ...

Javascript java

Mar.04,2021
The use of Github markdown language
can you only use the markdown language in README.md in github? I ve experimented with using the markdown language in other files, but it doesn t work. Ask for popular science ~ ...

Javascript java python

Mar.04,2021
The Conten-download load time is too long.
as shown in the figure above, what is the cause? Front end or back end? I have no idea at all. ...

Javascript java

Mar.05,2021
Smtp sends email to add signature
python smtp send email setup signature? you can also say how it is sent in other languages ....

Javascript java php python

Mar.05,2021
Ask questions about the development environment
the development process of the java, backend of our company is to pull the svn warehouse code on its own, and then configure the local server to run the code pulled by svn on the local server. After the local development is completed, the code will be u...

Javascript java html node.js html5

Mar.06,2021

Menu