I have developed an application that rely heavily on database on following environment-
200 concurrent applications access API to execute read all records from database. In response, 1 million record is returned by the database to node server and node server returns the same packet to client application. The response time is 6407.9 msec which is very high.
200 concurrent API call is made every second.
I also used
compression module, but it did not help much.
Can anyone please let me know how to speed up the response time?