Re: ONLINE 7.2 tuned to simulate SE x.x

Hoo-boy! This was a very ill-advised decision. You don't just install OnLine 7.2 - you should have done training or had consultants in to advise you of the various things you can and should do to make OL fly. You don't mention your hardware config, but OL7 takes a *lot* more RAM than SE. On 8 Jan 97 at 3:08, Rudy Fernandes wrote: > We have recently 'upgraded' from SE 5.0 to ONLINE 7.2. Performance > dropped dramatically on the first day (2 days back), to about 10% of > SE performance. This is not unheard of. Your ONCONFIG might be totally inappropriate. > A frenetic 36 hours later performance is up to about 30 to 50% of SE > level - the users are no longer tearing their hair out, they just > have long faces. > > With SE, I hardly had any configuration to do. Update Statistics > once in a while, keep meaningful indexes, recreate them once in a > while, make sure the programs are using them, keep the log on > different disk and I'm in business. This is quite correct. > When using ONLINE, its a different ballgame with the myriad of > tunable parameters. > > It would seem logical that a large majority of parameters of ONLINE > are also used by SE, except that the DBA cannot tune them. This is *completely* false. OnLine has a completely different internal architecture than SE. Communication between client and server is completely different. In fact, if you didn't recompile and are using the Delay Module, er, Relay Module, that alone could be your problem. > What are they? And what are their values under SE? You should really go on the DSA System Admin course, and possibly Performance Tuning For OnLine7. HTH. -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...