Allan, Please can you explain to your audience how long have you been around and how long have you been workling with Adabas, IMS and DB2 ?
Please define also what type of work have you been doing with all these Database software packages, if you can still remember.. Why ? In the USA there is lots of people that claim that they are "experts".. specially if they work in a cage for a big company. Anton On Tue, 9 Oct 2007 08:11:23 -0500, Staller, Allan <[EMAIL PROTECTED]> wrote: ><snip> >Subject: ADABAS vs IMS vs DB2 Who is faster? >I spoke few days ago with an ADABAS specialist that claimed that ADABAS >is >much faster and has low overhead compared to IMS and DB2. Is this true? ></snip> > >As with most things in this business, it depends. > >The first question to ask is "What source are you citing to support your >claim? Depending on the configuration and tuning options ADABAS may or >may not be faster than DB2. DB2 may or may not have a smaller footprint >than ADABAS. > >Because IMS uses an entirely different technique to access data, it >*most likely* is somewhat faster than either IMS or DB2. > >In order to obtain this speed, the flexibility of using SQL is >sacrificed. >(Actually it is the other way around IMS preceded DB2/ADABAS by several >years. > >The relative speed that is important is the one for *YOUR* workload. >Anything else is meaningless noise. Thoroughly research the *features* >important to you and go with the product that provides the best feature >to price ratio for you. > >HTH, > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO >Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html

