SQL server – Stocks Data -How to Push Data To Client Application

5 pts.
Tags:
ASP.NET
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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?

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following