If you have a large number of people reading data, you should use the DataReader paradigm. This way you can quickly enter and exit with the problem of outputting the circuit. I would also recommend if you pull data from the server that you cache it. Even if it is cached for only 1 second, it will improve the number of connections from the database that will retrieve the same data. Otherwise, you can quickly saturate your connection pool if you are not careful, as well as some kind of possible blockage.
source
share