Oninit cdi / Archive
Talk to an expert →

RE: CDR and serials

Posted in 1999

Topics: High Availability & Replication, Platform-Specific Issues, Versions, Editions & End-of-Life

William Raper — — source: Informix-list mailing list archive (1991-1998)

The answer is a rock solid "That Depends". If you are planning on an update-anywhere configuration, then the use of serials is highly unadvisable. However, if your East Coast machine is going to do all the database updates, and the West Coast machine is going to be used for reports only, then you have no issue. Bill Raper Senior Database Administrator Catalina Marketing 727-579-5134 Pager 727-529-8331 williamr@catmktg.com > -----Original Message----- > From: sfcawley [SMTP:sfcawley@interaccess.com] > Sent: Wednesday, September 01, 1999 7:18 PM > To: informix-list@iiug.org > Subject: CDR and serials > > Can CDR handle serial values? We have an application which currently > lives on > the East Coast. We are considering setting up a West Coast server to > handle > some of the daily load. The database makes liberal use of serials, and I > am > not sure how the database will perform if we put it on two servers. > > Server Version: IDS 7.31.UC2 > OS Version: Solaris 2.6 > > SC

↪ replying to William Raper
Lin-Chuan Lee — — source: Informix-list mailing list archive (1991-1998)

I also believe that the 'counter' is not increased when a row is inserted via replication. For example, East coast inserts row where serial column = 5 into west coast, west coast inserts serial column value 0, server assigns 1, not 6. THis was behaviour in 7.23 .... William Raper <WilliamR@catmktg.com> wrote: > The answer is a rock solid "That Depends". > If you are planning on an update-anywhere configuration, then the use of > serials is highly unadvisable. > However, if your East Coast machine is going to do all the database updates, > and the West Coast machine is going to be used for reports only, then you > have no issue. > Bill Raper > Senior Database Administrator > Catalina Marketing > 727-579-5134 > Pager 727-529-8331 > williamr@catmktg.com >> -----Original Message----- >> From: sfcawley [SMTP:sfcawley@interaccess.com] >> Sent: Wednesday, September 01, 1999 7:18 PM >> To: informix-list@iiug.org >> Subject: CDR and serials >> >> Can CDR handle serial values? We have an application which currently >> lives on >> the East Coast. We are considering setting up a West Coast server to >> handle >> some of the daily load. The database makes liberal use of serials, and I >> am >> not sure how the database will perform if we put it on two servers. >> >> Server Version: IDS 7.31.UC2 >> OS Version: Solaris 2.6 >> >> SC

Glossary