Indexed Subfiles and QTP

[Aikens, Curtis]

Default access like that will traverse the primary key tree just like any
indexed file won't it?

It isn't PowerHouse, it's just the fact that indexed reads are always slower
than sequential reads (even sequential reads in indexed files).

One should always evaluate performance needs when choosing file types - for
reading, you just can't beat a sequential file...


Curtis Aikens
Information Technologies
Dairyworld Foods 
(780) 486-8442

 -----Original Message-----
From: 	Robert Mills [mailto:robert.mills@windsong-services.co.uk] 
Sent:	Thursday, January 11, 2001 5: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.