On Sun, Jan 08, 2006 at 10:57:21AM +0200, Tsirkin Evgeny wrote: > > Jim C. Nasby wrote: > > >Personally, I'd just put the effort into setting up the insert/delete > >stuff and a means to periodically roll that info up into a summary > >table. I know that this has come up in the past, so you can probably > >find someone else who's already done this and might be able to provide > >you with code. Even if you have to write it from scratch, I doubt it's > >more work than what you've already put into trying to get the other > >scheme to work. > > > Thanks.Do you think that using LISTEN/NOTIFY mechanism for rolling up > the summary table > could be used? Sure, although on a busy system it might be better to just poll once a minute or so. I'm not sure what the overhead for a NOTIFY is, but I imagine it would start to add up if you were calling several times a second. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
