Indexed Subfiles and QTP

[Hamilton, Allison]

What platform?  

Besides the simple fact that indexed files in general are usually quite a
bit slower than flat files to access...  It would be an interesting exercise
to load the subfile information into your dictionary and use the data
portion of the subfile as a file and see if the access is any different
whether it's an indexed subfile or a regular file.

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