QTP Performance Issue

[Ohmes, Matt]

Hi Ken,

Well, in the particular QTP run in question, it could easily take quite a
bit longer (assuming a few things about the Run that I haven't gotten the
answer to yet.)

If the file being Output (updated) is also in the Access statement, QTP will
force a two pass process; all records read, then after all records are read,
re-read each one before you update it.  That means each record needs to be
read twice and updated once.  That's going to be slower than reading once
and writing once.  How much slower on a flat file? I don't know.

I suspect something else is going on however. I don't think it would take 3
to 4 times longer normally to update it.
Matt

Matt.Ohmes@Cognos.Com
Cognos Corporation
909 E. Las Colinas Blvd.
Suite 1900
Irving, TX  75039
214-259-6200
"Matt doesn't really know anything.  He just likes to pontificate a lot.
We refuse to acknowledge that he works for Cognos or that we have ever
met him or anyone with whom he's ever been associated.  Don't lend him
money and don't let him talk to your sister!" ;-)


-----Original Message-----
From: Ken Paul [mailto:KenRPaul@concentric.net]
Sent: Monday, July 09, 2001 7:07 PM
To: Karman, Al; powerh-l@lists.swau.edu
Subject: RE: QTP Performance Issue
<snip
>Why not spin a new subfile off instead of updating the current one?
<snip>

Is this really true?  Can the locking and the updating of a flat file really
be that much slower than just creating a new subfile in QUIZ?  Are we
talking twice as slow, 3 times, 4 times what?  Anybody else with QUIZ vs.
QTP performance info.

Thanks,

Ken

Ken Paul
Independent Consultant
KenRPaul@Concentric.Net
(303) 694-0920


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