QTP migration questions

[Pat Shugart]

I'm sorry. Forgot to mention we'll be migrating to an Oracle database
environment located on the HP9000 (HP-UX).

>>> "Joe Boyle" <atla38@dsl.pipex.com> 1/12/2005 8:38:09 AM >>>
I can't see what database you are using but memory tells me that Oracle
was
quite slow on Mpe, so, in my opinion, this will be faster on the 9000
without any changes.

As always, choose will be equivalent in performance to sql declare
cursor
syntax, but qtp 'select if' syntax will always be slower that anything
that
is processed within the database e.g. 5 minute runs reduced to 5
seconds
when using cursors.

Regards, Joe.

This e-mail and all information contained in it is confidential and may
be
legally privileged. If you are not the intended recipient, your access
to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the
sender
promptly by e-mail that you have done so. The content of this e-mail
and any
attachments sent with it may have been altered without the consent or
knowledge of the author.

-----Original Message-----
From: powerh-l-admin@lists.sowder.com 
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Pat Shugart
Sent: 12 January 2005 13:03
To: powerh-l@lists.sowder.com 
Subject: QTP migration questions

Hello all,

We're an Amisys shop in the final planning stages of our migration from
the
HP3000 to Amisys Advance on an HP9000. One of the decisions we need to
make
is what to do about QTP.

Choice #1: Convert QTP code to SQL (we use PL/SQL for other apps). As
I
understand it, performance is the greatest advantage of doing this.
The
"disadvantage" is that we have to rewrite all of our QTP code (and
document
it!) and it would take quite some time, as we have approximately 85
QTP
processes of varying degrees of complexity.

Choice #2: Continue to use QTP on the 9000. The advantage is that
relatively
few changes will need to be made to our code and the migration/test
period
can be shortened. The great unknown is performance. Is it (nearly) as
fast
as SQL code? For you HP3000 users, I draw a comparison to what happened
to
Suprtool. I understand it is not nearly the same tool it was on the
HP3000.
I haven't been able to find any sort of comparison docs between the MPE
and
HPUX versions of QTP. 

I would appreciate both real-world and theoretical thoughts regarding
our
choices. Please don't call or email me about migration "solutions".
Most of
those decisions have already been made. Although alternatives to the
choices
above are welcome...

This may have been a duplicate post * my first attempt was rejected
when I
sent it to the previous listserv address. Sorry.

Thanks in advance,


`....`....`....`....`....
Pat Shugart
Trinity Information Services
34605 Twelve Mile Road
Farmington Hills, MI 48331
248.489.6123
248.488.9195 (fax)



= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com 
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com 
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com 
http://lists.sowder.com/mailman/listinfo/powerh-l 
This list is closed, thus to post to the list you must be a
subscriber.