Distributing the load across SORTWORK files
Peter Bateman
pfbcs at hotmail.com
Wed May 17 18:30:57 CDT 2006
Hi all:
What causes rollover to the next sort file?
Is it when the user runs out of disk quota on that device or
can we set a parameter to cause rollover at a given number of PH
transaction records?
You can find out how big your record complex is by
entering SET TRACE SORT. QTP will display the size. by multiplying by
your expected number of records get a feel for the size of QTPSORT.
Regards,
Peter
>From: "Guy Werry" <guy.werry at hbms.ca>
>To: <powerh-l at lists.sowder.com>
>Subject: RE: Distributing the load across SORTWORK files
>Date: Wed, 17 May 2006 15:32:42 -0500
>MIME-Version: 1.0
>Received: from sowder.com ([207.210.77.31]) by
>bay0-mc12-f13.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Wed,
>17 May 2006 13:41:17 -0700
>Received: from sowder.com (localhost [127.0.0.1])by sowder.com
>(8.13.4/8.13.4/Debian-3sarge1) with ESMTP id k4HKaoU0001503for
><pfbcs at hotmail.com>; Wed, 17 May 2006 15:41:55 -0500
>Received: from hbffc003.hbms.hudbay.corp
>(framed-206-45-208-19.static.mts.net[206.45.208.19])by sowder.com
>(8.13.4/8.13.4/Debian-3sarge1) with ESMTP idk4HKXAUn020087for
><powerh-l at lists.sowder.com>; Wed, 17 May 2006 15:33:22 -0500
>X-Message-Info: LsUYwwHHNt1+THMnMH12QfHMPYSpoauzh41FJLrGDcs=
>Content-class: urn:content-classes:message
>X-MimeOLE: Produced By Microsoft Exchange V6.5
>X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Distributing the load
>across SORTWORK files
>Thread-Index: AcZ58FLu6QFV+9aTRmKSj58Kr50uzAAAF2Pw
>X-DRS-drsmilter-Version: drsmilter CVS $Id: drsmilter.py,v 1.82 2006/04/04
>13:38:59 drsmilter Exp $
>X-DRS-drsmilter-Version: drsmilter CVS $Id: drsmilter.py,v 1.82 2006/04/04
>13:38:59 drsmilter Exp $
>X-BeenThere: powerh-l at lists.sowder.com
>X-Mailman-Version: 2.1.5
>Precedence: list
>List-Id: Cognos PowerHouse 4GL <powerh-l.lists.sowder.com>
>List-Unsubscribe:
><http://lists.sowder.com/mailman/listinfo/powerh-l>,<mailto:powerh-l-request at lists.sowder.com?subject=unsubscribe>
>List-Archive: <http://lists.sowder.com/pipermail/powerh-l>
>List-Post: <mailto:powerh-l at lists.sowder.com>
>List-Help: <mailto:powerh-l-request at lists.sowder.com?subject=help>
>List-Subscribe:
><http://lists.sowder.com/mailman/listinfo/powerh-l>,<mailto:powerh-l-request at lists.sowder.com?subject=subscribe>
>Errors-To: powerh-l-bounces+pfbcs=hotmail.com at lists.sowder.com
>Return-Path: powerh-l-bounces+pfbcs=hotmail.com at lists.sowder.com
>X-OriginalArrivalTime: 17 May 2006 20:41:18.0036 (UTC)
>FILETIME=[3F75A940:01C679F2]
>
>Hey! I agree too, Ken. I use Qtp for almost all of my data extract stuff
>because it is SO much more powerful and convenient to create a subfile in
>Qtp than Quiz. Especially true if you have to do any sort of data
>manipulation / totalling, etc.
>
>Guy L. Werry
>Senior Systems Analyst
>Hudson Bay Mining & Smelting Co., Limited.
>
>-----Original Message-----
>From: Ken Langendock [mailto:Ken at Langendock.com]
>Sent: Wednesday, May 17, 2006 3:27 PM
>To: Guy Werry; powerh-l at lists.sowder.com
>Subject: RE: Distributing the load across SORTWORK files
>
>
>I agree with Guy
>
>When I wrote the sales system for Carling O'Keefe, we were sorting millions
>of records and we reduced the report job from 24 hours to under 20 minutes
>by using the SORT command at the OS level on a Vax.
>To sort the subfile at the OS level we had to exit QUIZ or QTP between
>executes, but it was well worth the effort.
>
>On the other hand, I still say extract all your data in QTP using Cursors
>and output phase reads and use QUIZ as a DUMB subfile reporting tool will
>definitely improve the performance of an application and still be portable
>from one platform to another..
>
>A combination of the two would be the ultimate approach.
>
>Ken
>
>-----Original Message-----
>From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
>[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
>Behalf Of Guy Werry
>Sent: May 17, 2006 3:35 PM
>To: powerh-l at lists.sowder.com
>Subject: RE: Distributing the load across SORTWORK files
>
>
>John,
>
>My world is Hp-Ux and before that MPE-ix, but I think the advice would
>still apply.
>
>The ideal way to do something like this is to write to and INDEXED SUBFILE,
>which has the index in the order that you require.
>
>That way the records are "inserted" (written) in the order of the index. A
>quiz report can then just read the resulting subfile without having to do
>the sort at all. Yes, the process that creates the subfile is slow, but
>the report is very fast and the overall load on the system is less.
>
>Failing that, if you don't have indexed subfiles available I would
>seriously consider putting another file definition into the dictionary.
>
>Other than that, a system sort utility would be a good idea.
>
>Guy L. Werry
>Senior Systems Analyst
>Hudson Bay Mining & Smelting Co., Limited.
>
>-----Original Message-----
>From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
>[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of
>John Stires
>Sent: Wednesday, May 17, 2006 2:01 PM
>To: powerh-l at lists.sowder.com
>Subject: Distributing the load across SORTWORK files
>
>
>We are doing a very large sort in quiz. It consistently runs for a time
>and then dies. We have 10 SORTWORK files defined, but only one seems to be
>used. It grows to several million blocks before the process dies. The
>others are virtually untouched.
>
>We are running OpenVMS V6.2 with PowerHouse version 7.10E6.
>
>Does anyone have a suggestion on how to distribute the sort load across
>multiple SORTWORK files.
>
>
>Thanks in advance for any help any of you can offer on this.
>
>John Stires
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the
>list archive at Google.
_________________________________________________________________
Take charge with a pop-up guard built on patented Microsoft® SmartScreen
Technology
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
Start enjoying all the benefits of MSN® Premium right now and get the
first two months FREE*.
More information about the powerh-l
mailing list