QTP migration questions

[Robert Edis]

G'day Pat

My experience with SQL cursors is not good.  If you
can recode QTP into SQL without having to resort to
the use of cursors then you will probably see a
performance gain.

SQL is not as "logical" to program in as QTP as it
typically doesn't have discrete boundaries like
REQUESTs.  This makes it a bit harder to understand
and debug for me. 

Blue


--- Pat Shugart <ShugartP@trinity-health.org> wrote:

> 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.
>