Indexed Subfiles and QTP

[Neil Harvey]

We use Indexed subfiles extensively (MPE + PH 8.19), especially for take on
and transition.

There is most definitely a performance problem with QTP - in "session" mode
- using Indexed subfiles as either the primary or a linked file. 

It's to do with locking.

Our work around (given to us by the local representatives of PowerHouse) was
to "set file xxxxx open exclusive" for each indexed subfile in the request. 

It's possible to get a performance improvement of up to 400 times -
important when you deal with 40,000,000 records ;)

There is also some parameter that can be specified with the qtp command
file/udc, that somehow affects locking, but it sounded too dangerous to me.


Regards

Neil


-----Original Message-----
From: Catherine Litten [mailto:catherine.litten@valleypres.org]
Sent: 12 January 2001 01:43
To: 'PowerHouse List'
Subject: RE: Indexed Subfiles and QTP


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