SV: SV: write to file with quick /using quiz instead
Jari.Kaljunen@teliasonera.com
Jari.Kaljunen@teliasonera.com
Mon, 20 Sep 2004 15:36:47 +0200
Hi,
there will be "report" from 4 different tables. Of course we could have several quiz-runs producing files with additional sorting fields and then merge the files omitting sorting fields.
Then there would be 2 problems left: disc space for the intermediate files and conversion of characters &,<,>,'," to xml-entities which is not very practical i quiz.
/Jari
-----Ursprungligt meddelande-----
Från: Joe Boyle [mailto:joeboyle_adt@hotmail.com]
Skickat: den 17 september 2004 23:28
Till: Kaljunen, Jari S. /TSS - Sergel Kredittjänster /+46-8-4526435; powerh-l@lists.sowder.com
Ämne: RE: SV: write to file with quick
why not allow the performance of quiz to generate the subfile and then use the DCL command 'CONVERT/FDL' to convert the file to the required sequential format. It may even be the case, that if the 'nodict' qualifier is used when creating the subfile, then the subfile need only be renamed and copied to the required directory.
I am guessing that a 'nodict' subfile will have a sequential rather than direct record format; you could always use the analyse command to examine the subfile's record format if you aren't sure.
Presumably, once the file is built, subsequent updates will be writing fewer records into the file, and the slow performance of Quick may not be as great an issue - or you could even go back to Qtp.
Regards, Joe.
This e-mail and all information contained in it is confidential and may be legally privileged. If you are not the intended recipient, your access to this e-mail is unauthorized. Any use, dissemination, distribution, publication or copying by you of this e-mail or any of the information contained within it is prohibited and may be unlawful. Do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. The content of this e-mail and any attachments sent with it may have been altered without the consent or knowledge of the author.
From: powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Jari.Kaljunen@teliasonera.com
Sent: 16 September 2004 20:42
To: powerh-l@lists.sowder.com
Subject: SV: SV: write to file with quick
You mean file asc600 designer open append ?
Well, it didn't help..
/Jari
-----Ursprungligt meddelande-----
Från: Peter Bateman [mailto:ppfb@hotmail.com]
Skickat: den 16 september 2004 21:02
Till: powerh-l@lists.sowder.com
Ämne: RE: SV: write to file with quick
I would try 'file asc600 designer open append' It may be a machine specific option.
But I didn't see it in the manual though.
Regards,
Peter
>From: <Jari.Kaljunen@teliasonera.com>
>To: <powerh-l@lists.sowder.com>
>Subject: SV: write to file with quick
>Date: Thu, 16 Sep 2004 12:22:20 +0200
>
>Hello again,
>
>a little test without reading database still very slow (actually no difference...). It takes 49 s to run this with 100 records on subfile. The result file is 20100 lines.
>
>I even wrote a test quiz reading the same subfile and having 200 defines, each including systime and some more, each defined item written on an own line. It takes quiz 3 s to write these 20000 lines.
>
>
>/Jari
>
>
>screen test_writing_file menu stopscreen
>
>file *ik006002 designer
>file asc600 designer
>
>temp t_count
>
>procedure internal write
> begin
> for 200
> begin
> let t_count = t_count + 1
> let rec600 = asc(t_count) &
> + " " + asc(systime) + " procedure internal write "
> put asc600 reset
> end
> end
>
>procedure initialize
> begin
> let t_count = 0
> while retr ik006002 seq
> begin
> let rec600 = asc(t_count) &
> + " " + asc(systime) + " procedure initialize "
> put asc600 reset
> do internal write
> end
> return
> end
>
>build
>
>-----Ursprungligt meddelande-----
>Från: Johnson, Harold A EDUC:EX
>[mailto:Harold.A.Johnson@gems1.gov.bc.ca]
>Skickat: den 15 september 2004 17:50
>Till: Kaljunen, Jari S. /TSS - Sergel Kredittjänster /+46-8-4526435;
>powerh-l@lists.sowder.com
>Ämne: RE: write to file with quick
>
>
>Are you sure the performance problem is with the writing and not with the
>reading of the original data? I would suspect a problem there instead.
>
>
>-----Original Message-----
>From: powerh-l-admin@lists.sowder.com
>[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of
>Jari.Kaljunen@teliasonera.com
>Sent: 2004 September 15 8:41 AM
>To: powerh-l@lists.sowder.com
>Subject: write to file with quick
>
>
>Hello,
>
>I am writing to
>
>File: ASC600
>Organization: SEQUENTIAL
>Type: RMS
>Open: ASC600
>Record Format: Variable
>Supersede: No
>Records & Sizes: ASC600 600 bytes
>Item Type Size Occ Offset
>REC600 CHARACTER 600
>
>in quick using let and put as follows
>
>let rec600 = "<HeaderRef2>" + asc(arnr of arenden,8) + asc(parmblnr,2) &
>+ atgkod of atgkoder + "</HeaderRef2>"
>
>put asc600 reset
>
>
>The performance is very poor. The administrator believs that quick closes
>and opens the file all the time.
>Can that be true?
>What should I do?
>
>We are creating an xml-file (it will be about 5 GB) with data from several
>tables and our solution with qtp needed too many subfiles and sortings using
>lots of space.
>
>/Jari
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@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.
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@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.
Don't just Search. Find! The new MSN Search: Fast. Clear. Easy. = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: powerh-l@lists.sowder.com Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com Unsubscribe: "unsubscribe " in message body to powerh-l-request@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.