Which is faster?

[Joe Boyle]

for those that might not,  

for quiz, qtp and quick, 'select if' and 'select record if' are evaluated by
the quiz, qtp and quick process only after each record has been read into
the buffer (using up cpu and IO) - whereas with choose and access statements
(or cursor syntax) the selection is done in the db before anything is
returned to the quiz, qtp or quick process - which is a very efficient use
of cpu and IO - and consequently much faster.

In the case of 'select record if' and 'select if' these options have no
connection with SQL's 'select col-set from table-set...' syntax and are not
sent to the database; they are applied only within the quiz, qtp or quick
process.

With 'select record if', the attempt to build a record complex is aborted at
the time the condition fails, which means the decision to get the next
record complex instead can be made faster; whereas (generally speaking) with
'select if', the attempt to build a record complex is aborted only after all
records in the access are read in to quiz, qtp or quick process - and
therefore, is generally slower than 'select record if'.

Quick is a little more complicated, but the general idea is sound.

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
fernando.olmos at hpa.com.au
Sent: 05 April 2006 02:04
To: Bob.Deskin at cognos.com; darren.reely at latticesemi.com
Cc: powerh-l at lists.sowder.com
Subject: RE: Which is faster?

Thank you Bob and Darren.

I understand now.
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and
intended
solely for the use of the individual or entity to whom they are addressed.
If
you received this e-mail in error, please notify the HPA Postmaster,
postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For
more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at 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.