Which is faster?

[fernando.olmos at hpa.com.au]

I am using QUIZ, but I know what you mean in QTP. The database is
Oracle.
 
However, I am not sure what the "input phase" really means. Is an ACCESS
statement going to run a Oracle query in the background and then return
the records to PH to filter out (the SELECT IF), or is PH going to
filter the data in the query before retrieving the records (as in SELECT
tbl IF)?
 
-----Original Message-----
From: Ken at Langendock.com [mailto:Ken at Langendock.com] 
Sent: Tuesday, 4 April 2006 2:17 PM
To: Fernando Olmos; powerh-l at lists.sowder.com
Subject: RE: Which is faster?


Hello Fernando, 
You didn't specify if you were using QTP or QUIZ.
You also didn't tell us the database (Oracle, ISAM, Image, RDB, etc)
 
If you are using QTP, another way is to open the second file in the
output phase.
 
Access table_x
  select if field1 of table_x = 1234
 
Output table_y &
          add &
          update &
          if 1 eq 2 &
          noitems &
          via order_no &
         using order_no
 
  set file table_y open read.
 
I found that by opening every file, that is not required in the input
phase, this way speed up the processing dramatically. This way the input
buffers are smaller for processing/sorting etc.
 
Ken
-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of fernando.olmos at hpa.com.au
Sent: April 3, 2006 11:54 PM
To: powerh-l at lists.sowder.com
Subject: Which is faster?



I have a table (X) which has over 200 thousand records and is linked to
another table (Y) as one-to-one. 

I need to select certain records from the entire complex, and I was
wondering which one of these would do it faster? 

[1]     access table_x link order_no to order_no of table_y 
        select if field1 of table_x = 1234 

of is this faster? 

[2]     access table_x link order_no to order_no of table_y 
        select table_x if field1 of table_x = 1234 

I figured that either way is the same, but I've timed the 2nd option and
it's remarkably faster. Is this because PH is actually filtering out the
records in the query, at the table level, if you say "select table if",
as opposed to waiting for the entire record complex and then applying
the filter?

Thanks guys 

Fernando Olmos 
MIS 
Senior Analyst Programmer 

HPA
Direct:  03 9217 5411
Mobile: 0410 382 857
Fax:     03 9217 5716 

 <file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au> www.hpa.com.au



**********************************************************************

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

**********************************************************************
**********************************************************************
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
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060404/8a2c7d6d/attachment-0001.htm