Indexed Subfiles and QTP

[Catherine Litten]

I always used a non-indexed subfile if I can.  I have noticed It takes
longer to create an indexed file, then non-indexed.  An indexed subfile is
my last resort for connecting data, however small ones created for choose
statements work wonders.  Most of the time a non-indexed file works just
fine if your code is written correctly.

********************************************
Catherine Litten,
Senior Programmer/Analyst
Valley Presbyterian Hospital (www.valleypres.org)
15107 Vanowen Street
Van Nuys, Ca  91405-4597
Phone (818) 782-6600 x 2140     Fax (818) 902-5202
********************************************
The thoughts, comments, and opinions expressed herein are mine and do not
reflect those of my employer, or anyone else.
********************************************


-----Original Message-----
From: owner-powerh-l@sphere.swau.edu
[mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Robert Mills
Sent: Thursday, January 11, 2001 4:19 AM
To: 'PowerHouse List'
Subject: Indexed Subfiles and QTP


Hi all,

Anybody out there finding that access indexed subfiles in QTP is v..e..r..y
s..l..o..w compared to non-indexed subfiles?

Take the following chunk of code:

> cancel clear
> set default
> set process limit 2000000
> set lock file update
> access *subfile
> output outfile add
>   item item1 final
>   item item2 final
> go

If the 'subfile' is a 'flat' file then it will run about 2000 times faster
that the 'indexed' file.

Am I doing something wrong OR is this a feature of PowerHouse?

+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
|Robert W.Mills (Systems Development Manager) |
|Windsong Services, St. Mary Cray, ENGLAND    |
|Tel  : +44 (0)1689 870622 x3005              |
|Fax  : +44 (0)1689 899026                    |
|Email: Robert.Mills@windsong-services.co.uk  |
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

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