Re: Oracle vs Informix comparison

Hi Thomas, This was an interesting post. Do you mind if I ask for some clarification? On 7 Dec 96 at 19:51, tkyte@us.oracle.com wrote: > At some point in time after the application commits, the system will pick up the > changes, transmit the transaction (not individual statements but the whole > transaction) to other sites to be replayed. The end user is not waiting for > this to happen, the 2pc is used by the system to ensure a transaction gets sent > to a remote site at least once and at most once. the 2pc is never used by the > client application in this scenario. the 2pc is used to gaurantee the data gets > propagated correctly. Do you have any control over the timing of this? > Oracle's replication works with disconnected (no network available) users as > well as connected users. If the following, wrong, timeline where accurate, > disconnected users could never update information. what you have described is > syncronous replication. While Oracle supports that if you want, our replication > uses asyncronous replication techniques. You have to go out of your way to do > syncronous replication. While I followed the gist of this, I couldn't quite figure out what you meant with: "If the following, wrong, timeline where accurate, disconnected users could never update information." Could you perhaps give an example? > - adding more readers to my log files (the single largest point of contention in > an RDBMS) isn't going to speed up my database either. I'm not sure if I agree with this, but we'll let it slide... :-) > - the stored procedures/triggers, being system generated and managed, cause as > many applicatoin level mess-ups as do primary keys, foreign keys, check > constraints, etc. Just another constraint. This is *very* interesting - you as a developer don't have to code the sp's/triggers? How do you specify what must get replicated and where to? What happens if you add new servers which must also be updated? For once, I'm not just being difficult, just interested to see how you guys do it. -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...