[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Notification services for live data

s_armondi

3/19/2007 11:22:00 AM

Hi all,
I've been tasked to develop a system to pick live prices
up from various sources (various APIs) and store them in a database
(SQL server 2005). All good so far - but as new prices come in (which
can be anywhere between once per second and once per hour on illiquid
days) I also need to notify clients, which will be winforms
applications sitting on our corporate LAN. I thought about using
Notification Services to do this - each client subscribes to the
prices it's interested in, when the new prices come in an event is
generated and the relevant subscribers are notified.
Does this sound like a feasible architecture? Or does anyone have any
other suggestions?
Thanks,
SAM

2 Answers

AlterEgo

3/19/2007 5:07:00 PM

0

Sam,

This is a poster child application for NS. From what you've told us, I would
recommend you use it.

-- Bill
<samuele.armondi@inenco.com> wrote in message
news:1174303347.236831.261070@o5g2000hsb.googlegroups.com...
> Hi all,
> I've been tasked to develop a system to pick live prices
> up from various sources (various APIs) and store them in a database
> (SQL server 2005). All good so far - but as new prices come in (which
> can be anywhere between once per second and once per hour on illiquid
> days) I also need to notify clients, which will be winforms
> applications sitting on our corporate LAN. I thought about using
> Notification Services to do this - each client subscribes to the
> prices it's interested in, when the new prices come in an event is
> generated and the relevant subscribers are notified.
> Does this sound like a feasible architecture? Or does anyone have any
> other suggestions?
> Thanks,
> SAM
>


s_armondi

3/20/2007 8:16:00 AM

0

Bill,

Thanks for the reply. So will server performance be adequate in such a
scenario? i.e. will clients be notified near-instantly when new prices
arrive or will there be a delay?
Thanks,
S

On 19 Mar, 17:06, "AlterEgo" <altereg...@dslextreme.com> wrote:
> Sam,
>
> This is a poster child application for NS. From what you've told us, I would
> recommend you use it.
>
> -- Bill<samuele.armo...@inenco.com> wrote in message
>
> news:1174303347.236831.261070@o5g2000hsb.googlegroups.com...
>
>
>
> > Hi all,
> > I've been tasked to develop a system to pick live prices
> > up from various sources (various APIs) and store them in a database
> > (SQL server 2005). All good so far - but as new prices come in (which
> > can be anywhere between once per second and once per hour on illiquid
> > days) I also need to notify clients, which will be winforms
> > applications sitting on our corporate LAN. I thought about using
> > Notification Services to do this - each client subscribes to the
> > prices it's interested in, when the new prices come in an event is
> > generated and the relevant subscribers are notified.
> > Does this sound like a feasible architecture? Or does anyone have any
> > other suggestions?
> > Thanks,
> > SAM- Hide quoted text -
>
> - Show quoted text -