Re: Informix Online Performance

Andy Mason wrote:- > Maybe there's a FAQ for this; if so please direct me to it and > I'll read it there. Thanks. > > I'm trying to get a quick overview of the performance improvement of > Online over SE. Eventually, I'd like to do some serious benchmarking, > and if anyone has some good ideas about how to go about it I'd be > very interested, but for now I'm just looking for some very > approximate figures - e.g. is the performance improvement > more like 20% or 80%. We're using SCO 3.2.4.2 and are considering > moving to OS 5 in the future. Andy help would be appreciated. > > Thanks, > > Andy Mason > > > There are no broad-brush figures on performance figures that are reliable because every application is different. However, I have witnessed performance improvements without code or schema change such as SE 25 seconds 35 minutes OnLine 8 seconds 10 minutes These were not on SCO but I have not found the hardware platform to make much difference to the level of performance improvement. In both cases the measurements were on an artificially loaded system, but you can't have everything. And remember, OnLine is not only justified for the performance improvement. The fast-recovery and archiving facilities make a significant difference. BTW the figures I quited were with OnLine 5 versus SE version 5. With the performance improvements in OnLine DSA I would expect significant improvement on even those figures. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc