write to file with quick

[Deskin, Bob]

Without seeing the code, we can't tell exactly what's happening. We do not open and close the file for every write by default, however we may be posting an end of file. There are also file locks to consider.

What you may be getting is file contention in a multi-user environment.

Bob Deskin              
Senior Product Manager, Application Development Tools
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
bob.deskin@cognos.com (613) 738-1338 ext 7268

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Johnson, Harold A
EDUC:EX
Sent: September 15, 2004 11:50 AM
To: 'Jari.Kaljunen@teliasonera.com'; powerh-l@lists.sowder.com
Subject: 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. 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.