Helen Borrie wrote:

>>The DBMS is not the piece that should be responsible for the "notify" event.
>
> Aaach, the DBMS is the only piece that knows for sure that the event happened.
>
>>I would suggest that the client send a multicast on the LAN to notify the
>>other clients that new data is available.
>
> Bleh, are you saying that client applications should take responsibility
> for notifying changes of database state to other clients?
>
> Coo. The "MS" in "RDBMS" doesn't stand for "Microsoft", you know!

On the other hand, Helen, a dedicated message does wonders
for network load :)
Do I actually need it now that BT finally fixed the Frame
Relay installations - possibly not, but since the customers
pay on network load it helps ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services