QTP Sort

[WITKOPP@IDT.COM]

Were you only timing sort times, and not possible
subfile create times? It's very slow to create a subfile
from scratch because RMS has to keep extending the
file.

> We had an issue with sorting large amounts of data once.  We tried using
> QUIZ 
> and/or QTP but found it too slow.  I asked Cognos what the sort mechanism
> was 
> and they said PH piped out to the VMS Sort utility.  We decided to run a 
> preprocess in QUIZ and output to a data file, execute the VMS Sort utility 
> from DCL and do final processing in QTP/QUIZ.  The result was a dramatic 
> improvement in performance, contrary to Cognos's advice. 
>  
> If you are using an RDBMS, adding indexes to tables to also dramatically 
> improve performance as the database does the work instead of PH.  
>  
> I hope this helps. 
>  
> Robert Edis (Blue) 
> Technical Consultant 
> Michigan, USA 
> (VAX/VMS, ORACLE Rdb, PowerHouse 4GL)
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> 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
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.