Re: HELP : S.E (7.x) nearly faster than OWS (7.x)
My experience with SE is that it is fast, *extremely* easy to administer, and totallly reliable. So, what's wrong with that? Nothing. SE RULES!!!! David Williams <djw@smooth1.demon.co.uk> wrote: >In article <350B16E1.4072DCE3@arrakis.es>, martin <ramp@arrakis.es> >writes >>Mariusz Malogrosz wrote: >>> >>> I did a benchmark test a while ago , comapring >>> WS , OL, SE . Using hp9000 , 1 GB ram , 2 CPU's . >>> The test consisted of a simulation running a 4gl order entry >>> application using benchmarking tool called Mercury Loadrunner. >>> I run 10, 20 , 30, 40 and 50 user tests , bottom line was >>> the difference was minimal OL was 1.01868 % faster then SE and >>> same as WS . Note this is a OLTP app , DSS may be different ... >>> >>> Question how many CPU's do you have , my theory is that >> >> I have one CPU (MIPS 10000 at 200MHZ + $MB 2nd levl. chache), >> and it's a OLTP system with $GL programing >> > Try yanking the power out when many users are doing updates. > SE ends up with a corrupt database. > Online does not, it does fast recovery and rollsback open > transactions. > One a single CPU machine I doubt you would see much difference. > Online however is more reliable than SE. >> >>> on 2 CPU machine there is little benefit , things change as you get into >>> large databases and many CPU's .... I know PDQ is great for DSS ... >>> >>> Mariusz >>> >>> MARTIN <ramp@arrakis.es> wrote in article <35088D80.32CE70DB@arrakis.es>... >>> > After the tuning of on Line Work Group Server 7.20UC2 in a Siemens >>> > machine with 256 i have compared performance : S.E and OWGS have the >>> > same performance . >>> > >>> > I can not understad . Do you? >>> > >>> > I have all in on line : buffer o.k , kaio , access to two disk , small >>> > check point , temp dbspaces , raw devices >>> > >-- >David Williams >Maintainer of the Informix FAQ > Primary site (Beta Version) http://www.smooth1.demon.co.uk > Official site http://www.iiug.org/techinfo/faq/faq_top.html >I see you standin', Standin' on your own, It's such a lonely place for you, For >you to be If you need a shoulder, Or if you need a friend, I'll be here >standing, Until the bitter end... >So don't chastise me Or think I, I mean you harm... >All I ever wanted Was for you To know that I care