I am doing a project/web application where i need to show different stock related data in various pages.
Like in home page i have a real time stock ticker.
In home page again i have to show top traded stocks.
Then in some other page i have a page where all stocks and their realtime prices are displayed.
Then in some page i have to display top gainers and loosers.
Above all pages will autoupdate so that realtime stock prices are updated at client view.
So in short every page is displaying real time stock data.
I am building my project in asp.net 4.0. As its related to realtime data i cant cache any of the data (sqlcachedependency,httpcontext.. etc). And also being a trading site it will have huge number of clients who will be connected to the site at a particular time. Hence i cant create a sql connection or send a sql request for each and every request. So how should i proceed in architechting the above said web applicaion.
Every single suggestion of yours will help me to proceed in right direction.
View Complete Post