Which is faster?

[fernando.olmos at hpa.com.au]

Thanks Joe! That about covers the lot I need.

Incidentally, has anyone here considered writing more on the wikipedia
article for Powerhouse?

http://en.wikipedia.org/wiki/Powerhouse_programming_language

It's pretty scant at the moment.

chao

-----Original Message-----
From: atla38 at dsl.pipex.com [mailto:atla38 at dsl.pipex.com] 
Sent: Wednesday, 5 April 2006 2:27 PM
To: Fernando Olmos
Cc: powerh-l at lists.sowder.com
Subject: RE: Which is faster?


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