SQL server – Stocks Data -How to Push Data To Client Application
ASP.NET, Push technology, Real time, SOA, SQL Server, SQL Server 2005, SQL Server performance, Web development, Web services, XML
My client application providing real time stock quotes takes data using a xml webservice which pulls data from sql server 2005.with number of clients increasing for same piece of data, the sql server is being queried again and again.Is there a way to push data from sql 2005 to client application instead of pulling data.Say, if i make to make it for 200 mostly frequently queried symbols,push data into client application and rest infrequently used ones,i can keep existing architecture.
Thanks
Software/Hardware used:
Software/Hardware used:
ASKED:
August 25, 2008 5:53 AM
UPDATED:
August 27, 2008 8:45 AM
Answer Wiki:
Basically no there is not. Your best bet will be to setup some intelligent caching within your web layer.
You could define within a config file on the web servers the ticker symbols that you want to cache, then store the values in memory getting new ones every 10-20 seconds or so as needed. This will however mean that you would be sending out old data for that amount of time.
How many records are in your table? You may need to look at you indexes to improve performance. Additional RAM may also help. What does your hardware config look like?
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
3