write to file with quick

Johnson, Harold A EDUC:EX Harold.A.Johnson@gems1.gov.bc.ca
Wed, 15 Sep 2004 08:49:39 -0700


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.