Indexed Subfiles and QTP

[Robert Mills]

Thanks for all the replies. It looks as if some further testing is required.
Will post details when completed.

-----Original Message-----
From: Martin McDonough [mailto:MartinM@Rosebys.com]
Sent: Friday, January 12, 2001 9:37 AM
To: 'Neil Harvey'; 'PowerHouse List'
Subject: RE: Indexed Subfiles and QTP


I also, have seen the problem, but as Neil says, only in 'session' mode, the
same applies in quick & quiz as well.

The parameter Neil talks about is :QTP INFO="NOBREAKSET" and can be used for
quiz & quick also.

Martin McDonough

> -----Original Message-----
> From:	Neil Harvey [SMTP:neil@nha.co.za]
> Sent:	12 January 2001 05:26
> To:	'PowerHouse List'
> Subject:	RE: Indexed Subfiles and QTP
> 
> 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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.