QTP migration questions

[Joe Boyle]

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.