<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
