Nicholas Mickey wrote:

>I doing some testing with moving allbase(hp3000/mpe/ix 6.0) to
>oracle(ver 8.1)(sunsystems).  I will be using the hp3000 as my frontend
>and oracle on the sunsystems box as my backend, but my performance has
>dropped by 300%, does anyone have any ideas?

Yes.  I would be fairly confident that your new combination of hardware,
OS and DBMS is significantly slower than what you had.

We have heard recently on this list how a major university was unable to
achieve acceptable performance with Oracle even on a very heavily loaded
up HP-UX system.  This is no surprise.

The combination of MPE/iX and the native databases, either Image/SQL or
Allbase/SQL, simply cannot be beaten without an enormous investment in
hardware (perhaps even 10 times greater).  While this may sound like an
outrageously bold statement to make, it is based on the experiences of
many, including us.

I would suspect your planned configuration is because the data needs to
be combined with some that was already in that Oracle database.  Or
perhaps there was a desire to use the latest version 8 of Oracle which
is not available (yet) on the HP3000.

Are either of these correct?  Is there any good business reason not to
continue to use Allbase?  While it is not as robust or popular as other
relational DB's, we have found it does everything we need and is
unparalleled in terms of cost and performance.

Also, have you considered running Oracle version 7 on the HP3000 system?
I wouldn't be at all surprised to find it runs much faster than version
8 on your Sun system.  By the way, if this were the case, your Oracle
license agreement would prevent you from telling us so.

Robert Joseph
The NPD Group
[log in to unmask]