> On Wed, Jan 03, 2007 at 07:47:34PM +0530, ramachandra(dot)bhaskaram(at)wipro(dot)com wrote:
>> Yes, our application is supposed to know *immediately* that a change in
>> the database has occurred since,
I'd recommend some sort of "whiteboard" layer or messaging fabric as an
option for this sort of thing. This offloads the notification element
from the database, and lets you pass along any data you want to the
listeners - even the complete record.
Also this sort of thing scales well to multiple listeners. Anyway, just
a thought...
Regards,
--
Dave Steinberg
http://www.geekisp.com/
http://www.steinbergcomputing.com/