CHOOSE and SELECT in QTP

Bourchi, H. bourchih@unive.nl
Thu, 25 Jan 2001 15:02:29 +0100


Goodday everyone,

I am working for an insurence company, which has several sort of products
(services).
At this moment, possible products are "A############", "C############",
"L############" and "O############", but in future could, new sort of
products be added. 
By a QTP program, user has to be able to do some processing on alle of
possible products.
He has to be able to choose, witch sort of products are subject of
processing. Possible choices has to be:
1- 	 "A############" products 
2- 	rest of the products.

My first solution was: 

access product_table
define product_choice char*1 = parm
choose product_item (case of product_choice 		&
			when "A" : "A@"			&
			when "L" :  "B@@")
Do processing ...

In case of A was QTP in 5 minutes finished and in case of L in 92 minutes!
92 minutes processing time seemed a bit strange. So I tried to campare it
with a SELECT statement construction:

access product_table
define product_choice char*1 = parm
select if product_item[1:1] <> "A"

Do processing ...

I was surprised when I saw a SELECT statement construction is almost 5 times
faster then a CHOOSE statement; Qtp was in 16 minutes finished. I am aware
of difference between "B@@" and "<> "A"". But I don't believe this is the
only reason for such a big processing time difference. Or I am doing
something wrong and saying something stupid?

We are running on PH 7.10.F2 and OpenVMS for ALPHA V7.1-1H1

Regards,
Hamid Bourchi
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.