Indexed Subfiles and QTP

[Jeff Hoffman]

Yea, had similar problem on MPE iX with largish (25,000 records) files.

It was quicker to build SQL DB files on the fly and use qtp, than to wait
for an indexed subfile job to finish.

Jeff 

>-----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.
>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
+ Jeff Hoffman                          + e-mail: JeffHoffman@goconnect.net +
+ Director          (ABN 93 083 502 630)+                                   +
+ WoniCon Pty Ltd   (ACN 083 502 630)   +                          ,-_|\    +
+ 21 Prices Circuit                     + voice: +61 2 9542 1527  /     \   +
+ Woronora    NSW     2232              +   fax: +61 2 9521 3979  \_,-._*   +
+ AUSTRALIA                             +                              v    +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.