Re: If You have an option to move from 7.3 to 9.3 or 9.4. Which one you

...snip... > Rajib's saved his best argument to the penultimate: most (but not all - care > to comment, Hal?) people have found performance improvements over other v9 > engines. > The one and only delete/insert benchmark I did (deleting about 17,000 rows from table a, then loading about the same number from a text file using load from... insert into... in dbaccess), comparing IDS 9.30.UC1 before the IDS 9.40.UC1 upgrade, and then the 9.40.UC1 after the install (same chunk configuration, same box, same everything) showed 9.40.UC1 was slightly slower than 9.30.UC1. I repeated the benchmark several times to be sure, making sure what was in the buffer pool was not impacting one over the other etc. etc. The deletes as well as the inserts were slower... We have our own servers as well clients' servers live on 9.40 and live happily with them, so I have not done too much digging into this... Hal Maner M Systems International, Inc. www.msystemsintl.com