What could be better - Dataset or datareader?

I have a stock market app that will often be used by millions of participants at the same time.
What could be the best option to retrieve data from my database based on database search and load times - or ? DataReader DataSet

+3
source share
1 answer

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.

+1
source

All Articles