Re: Upgrading On-Line 5.x -> 7.x

In article <4o7a2u$59u@impsets.dash.com>, johnc@ski-ralston.com says... > > >I am looking for any information concerning upgrading from OnLine 5.x to >7.x on a uni-processor machine. I have heard rumours of extreme >decreases in performance (up to 50%) when upgrading on a uni-processor. >Experiences (good & bad) would be greatly appreciated. Please include >information about your system configuration, specific problem(s), and >solutions if found. > My experience is over Digital ALPHA and it depends the kind of work you do in your database. In my case... large databases must have lots of memory (aprox 2x). CPus are important to but memory is fundamental. Pay atention to the construction of indexes (Update statistics is mandatory). Use ONPERF to see your querys running before enter in production! Alex p.nunes@mail.telepac.pr