Re: Sending large notifications.
It may be best to cache you records into another sql server table where
you can use the xml data type or a binary blob and pick them up later.
Most efficient would be to mark each record with a guid and stash them
in a sql table and them just send the user clients the guid. The user
clients then actually retreive the record from a simple webservice call
or whatever is simplest.
Another store would be to create a queue for each workstation client
and stash the records into there , they just then poll their own queue.
dont know if that helps at all
Kate patterson MBCS