Re: ANSI databases

David Natelson writes: |> Is is not true that all of the Informix TPC-C benchmarks are run with mode= |> ANSI ? I can't say for sure, but I don't know that ALL of them were run that way. The primary impetus for mode-ANSI in a TPC benchmark is that it reduces the messaging between client&server and the amount of writes to the logical log due to the fact that there are no "begin work"s in a mode-ANSI database. In the dog-eat-dog world of TPC benchmarks, every little bit helps. |> If so, and you "wouldn't touch a MODE ANSI database", why does Informix |> publish so many ads showing the number of TPC-C benchmarks they have run ? You are confusing two different issues. Informix publishes it's standings re: TPC-C results because it is something that differentiates us from our competition. None of our competition has published a TPC-C. That mode-ANSI databases were used for the TPC-C benchmarks is a result of the above "performance enhancement" associated with mode-ANSI databases. Bear in mind, however, that a TPC-C benchmark does not have to deal with the various restrictions of a mode-ANSI database on a day-to-day basis. It is these "difficulties" that prompts Jonathan to make the statements he did. To give another perspective, the "difficulties" of working with a mode-ANSI database are, to my mind, ones of discipline (I do not mean to imply that my colleague is in any way undisciplined ;-)). Naming conventions, careful database design (esp regarding primary keys), and careful application design are really all that is needed to avoid the "problems" commonly seen with mode-ANSI databases. So many of us have gotten into the habit of being a bit more cavalier in the above areas, so when we get bit as a result because of a mode-ANSI database, we are inclined to speak less than favourably (;-)) of them. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney