> At 11:27 11/07/00 +1000, Chris Bitmead wrote:
> >
> >> It was mentioned here that triggers could be used for
> async replication,
> >> as well as WAL.
> >
> >Same story. Major inefficency. Replication is tough enough without
> >mucking
> >around with triggers. Once the trigger executes you've got to go and
> >store
> >the data in the database again anyway. Then figure out when to delete
> >it.
> >
>
> The WAL *should* be the most efficient technique for
> replication (this said
> without actually having seen it ;-}).
That depends on how much you need replicated. If you replicate all or most
tables WAL will be very good, if you only need a few tables it wont.
Andreas
