Indexed Subfiles and QTP

[Merol Newman]

Hello Robert

I use indexed subfiles a lot, and I haven't noticed them being slow. But maybe
I'm not processing quite so many records!

Are you using MPE? That might make a difference - indexed subfiles didn't exist
when I worked on MPE. I now use VMS and Unix. My usual qtp would be

  access *subfile link to mainfile
  subfile save-mainfile include mainfile
  output mainfile update
  etc

and *subfile would usually be non-indexed, depending on what else I want to do
with it. But I really haven't noticed it makes any difference to the speed
whether it's indexed or not. (It makes a difference to the time taken to write
the subfile!)

I've just seen some other replies - it occurs to me that default access IS
sequential in VMS or Unix C-ISAM, but quite possibly not in MPE.

regards
Merol

merol.newman@ramesys.com
Ramesys, Eldon Way, Crick, Northamptonshire, UK. NN6 7SL
phone 01788 822133/823831, fax 01788 823601


> -----Original Message-----
> From: owner-powerh-l@sphere.swau.edu
> [mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Robert Mills
> Sent: 11 January 2001 12:19
> 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.