SV: write to file with quick
Joe Boyle
joeboyle_adt@hotmail.com
Fri, 17 Sep 2004 22:28:10 +0100
This is a multi-part message in MIME format.
------=_NextPart_000_0003_01C49D05.9CE46E70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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.
=20
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=92t sure.
=20
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 =96 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.
_____ =20
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
=20
You mean file asc600 designer open append ?
=20
Well, it didn't help..
=20
/Jari
=20
=20
-----Ursprungligt meddelande-----
Fr=E5n: Peter Bateman [mailto:ppfb@hotmail.com]
Skickat: den 16 september 2004 21:02
Till: powerh-l@lists.sowder.com
=C4mne: 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>=20
>To: <powerh-l@lists.sowder.com>=20
>Subject: SV: write to file with quick=20
>Date: Thu, 16 Sep 2004 12:22:20 +0200=20
>=20
>Hello again,=20
>=20
>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.=20
>=20
>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.=20
>=20
>=20
>/Jari=20
>=20
>=20
>screen test_writing_file menu stopscreen=20
>=20
>file *ik006002 designer=20
>file asc600 designer=20
>=20
>temp t_count=20
>=20
>procedure internal write=20
> begin=20
> for 200=20
> begin=20
> let t_count =3D t_count + 1=20
> let rec600 =3D asc(t_count) &=20
> + " " + asc(systime) + " procedure internal write "=20
> put asc600 reset=20
> end=20
> end=20
>=20
>procedure initialize=20
> begin=20
> let t_count =3D 0=20
> while retr ik006002 seq=20
> begin=20
> let rec600 =3D asc(t_count) &=20
> + " " + asc(systime) + " procedure initialize "=20
> put asc600 reset=20
> do internal write=20
> end=20
> return=20
> end=20
>=20
>build=20
>=20
>-----Ursprungligt meddelande-----=20
>Fr=E5n: Johnson, Harold A EDUC:EX=20
>[mailto:Harold.A.Johnson@gems1.gov.bc.ca]=20
>Skickat: den 15 september 2004 17:50=20
>Till: Kaljunen, Jari S. /TSS - Sergel Kredittj=E4nster /+46-8-4526435;=20
>powerh-l@lists.sowder.com=20
>=C4mne: RE: write to file with quick=20
>=20
>=20
>Are you sure the performance problem is with the writing and not with =
the=20
>reading of the original data? I would suspect a problem there =
instead.=20
>=20
>=20
>-----Original Message-----=20
>From: powerh-l-admin@lists.sowder.com=20
>[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of=20
>Jari.Kaljunen@teliasonera.com=20
>Sent: 2004 September 15 8:41 AM=20
>To: powerh-l@lists.sowder.com=20
>Subject: write to file with quick=20
>=20
>=20
>Hello,=20
>=20
>I am writing to=20
>=20
>File: ASC600=20
>Organization: SEQUENTIAL=20
>Type: RMS=20
>Open: ASC600=20
>Record Format: Variable=20
>Supersede: No=20
>Records & Sizes: ASC600 600 bytes=20
>Item Type Size Occ Offset=20
>REC600 CHARACTER 600=20
>=20
>in quick using let and put as follows=20
>=20
>let rec600 =3D "<HeaderRef2>" + asc(arnr of arenden,8) + =
asc(parmblnr,2) &=20
>+ atgkod of atgkoder + "</HeaderRef2>"=20
>=20
>put asc600 reset=20
>=20
>=20
>The performance is very poor. The administrator believs that quick =
closes=20
>and opens the file all the time.=20
>Can that be true?=20
>What should I do?=20
>=20
>We are creating an xml-file (it will be about 5 GB) with data from =
several=20
>tables and our solution with qtp needed too many subfiles and sortings
using=20
>lots of space.=20
>=20
>/Jari=20
>=20
>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
>Mailing list: powerh-l@lists.sowder.com=20
>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to=20
>powerh-l-request@lists.sowder.com=20
>http://lists.sowder.com/mailman/listinfo/powerh-l=20
>This list is closed, thus to post to the list you must be a subscriber. =
>=20
>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
>Mailing list: powerh-l@lists.sowder.com=20
>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=20
>http://lists.sowder.com/mailman/listinfo/powerh-l=20
>This list is closed, thus to post to the list you must be a subscriber. =
_____ =20
Don't just Search. Find! The new MSN Search:
<http://g.msn.com/8HMBENCA/2749??PS=3D47575> Fast. Clear. Easy. =3D =3D =
=3D =3D =3D =3D =3D
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D 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.=20
------=_NextPart_000_0003_01C49D05.9CE46E70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:r_ansi;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dblue>
<div class=3DSection1>
<p class=3DMsoPlainText><font size=3D2 color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p>=
</span></font></p>
<p class=3DMsoPlainText><font size=3D2 color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>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.<o:p></o:p></span></font></p>
<div>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy><span
style=3D'color:navy'><o:p></o:p></span></font></p>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>This e-mail and all information contained in it is =
confidential
and may be legally privileged. If you are not the =
intended</span></font><font
color=3Dnavy><span style=3D'color:navy'> </span></font><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>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.</span></font><o:p></o:p></p>
</div>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of =
</span></b>Jari.Kaljunen@teliasonera.com<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 16 September 2004 =
20:42<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> SV: SV: write to =
file
with quick</span></font><o:p></o:p></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>You mean</span></font><font =
size=3D2
color=3Dblue face=3D"r_ansi"><span =
style=3D'font-size:10.0pt;font-family:r_ansi;
color:blue'> file asc600 designer open append =
?</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:blue'>Well, it didn't =
help..</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3D"r_ansi"><span
style=3D'font-size:10.0pt;font-family:r_ansi;color:blue'>/Jari</span></fo=
nt><font
face=3DArial><span =
style=3D'font-family:Arial'><o:p></o:p></span></font></p>
</div>
<p><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;font-family:Arial'> <o:p></o:p></span></fo=
nt></p>
<p><font size=3D3 face=3DArial><span =
style=3D'font-size:12.0pt;font-family:Arial'> <o:p></o:p></span></fo=
nt></p>
<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>
<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Ursprungligt =
meddelande-----<br>
<b><span style=3D'font-weight:bold'>Fr=E5n:</span></b> Peter Bateman
[mailto:ppfb@hotmail.com]<br>
<b><span style=3D'font-weight:bold'>Skickat:</span></b> den 16 september =
2004
21:02<br>
<b><span style=3D'font-weight:bold'>Till:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>=C4mne:</span></b> RE: SV: write to =
file with
quick</span></font><o:p></o:p></p>
<div>
<div>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>I would
try 'file asc600 designer open append' It may be a machine specific =
option.<o:p></o:p></span></font></p>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>But I
didn't see it in the manual though.<o:p></o:p></span></font></p>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>Regards,<o:p></o:p></span></font></p>
<p style=3D'margin-bottom:12.0pt'><font size=3D3 face=3D"Times New =
Roman"><span
style=3D'font-size:12.0pt'>Peter<o:p></o:p></span></font></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>From: <Jari.Kaljunen@teliasonera.com> =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>To: <powerh-l@lists.sowder.com> =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Subject: SV: write to file with quick =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Date: Thu, 16 Sep 2004 12:22:20 +0200 =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Hello again, <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>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. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>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. =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>/Jari <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>screen test_writing_file menu stopscreen =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>file *ik006002 designer <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>file asc600 designer <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>temp t_count <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>procedure internal write <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> begin <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> for 200 =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> begin =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> &=
nbsp; let
t_count =3D t_count + 1 <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> &=
nbsp; let
rec600 =3D asc(t_count) & <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> &=
nbsp;
+ " " + asc(systime) + " procedure internal write " =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> &=
nbsp; put
asc600 reset <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> end =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> end <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>procedure initialize <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> begin <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> let t_count =3D 0 =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> while retr ik006002 seq =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> begin =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> let rec600 =
=3D
asc(t_count) & <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> &=
nbsp;
+ " " + asc(systime) + " procedure initialize " =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> put asc600 =
reset <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> do internal =
write <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> end =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> return =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> end <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>build <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>-----Ursprungligt meddelande----- =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Fr=E5n: Johnson, Harold A EDUC:EX =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>[mailto:Harold.A.Johnson@gems1.gov.bc.ca] =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Skickat: den 15 september 2004 17:50 =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Till: Kaljunen, Jari S. /TSS - Sergel Kredittj=E4nster
/+46-8-4526435; <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>powerh-l@lists.sowder.com <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>=C4mne: RE: write to file with quick =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Are you sure the performance problem is with the writing and =
not
with the <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>reading of the original data? I would suspect a =
problem
there instead. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>-----Original Message----- <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>From: powerh-l-admin@lists.sowder.com =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Jari.Kaljunen@teliasonera.com <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Sent: 2004 September 15 8:41 AM =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>To: powerh-l@lists.sowder.com <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Subject: write to file with quick =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Hello, <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>I am writing to <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>File: ASC600 <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Organization: SEQUENTIAL <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Type: RMS <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Open: ASC600 <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Record Format: Variable <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Supersede: No <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Records & Sizes: ASC600 600 bytes =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Item Type Size Occ Offset <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>REC600 CHARACTER 600 <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>in quick using let and put as follows =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>let rec600 =3D "<HeaderRef2>" + asc(arnr of
arenden,8) + asc(parmblnr,2) & <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>+ atgkod of atgkoder + "</HeaderRef2>" =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>put asc600 reset <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>The performance is very poor. The administrator believs that =
quick
closes <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>and opens the file all the time. =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Can that be true? <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>What should I do? <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>We are creating an xml-file (it will be about 5 GB) with =
data from
several <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>tables and our solution with qtp needed too many subfiles =
and
sortings using <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>lots of space. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>/Jari <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Mailing list: powerh-l@lists.sowder.com =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Unsubscribe: "unsubscribe <password>" in =
message
body to <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>powerh-l-request@lists.sowder.com =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>http://lists.sowder.com/mailman/listinfo/powerh-l =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>This list is closed, thus to post to the list you must be a
subscriber. <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Mailing list: powerh-l@lists.sowder.com =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>Unsubscribe: "unsubscribe <password>" in =
message
body to powerh-l-request@lists.sowder.com <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>http://lists.sowder.com/mailman/listinfo/powerh-l =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>>This list is closed, thus to post to the list you must be a
subscriber. <o:p></o:p></span></font></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><br clear=3Dall>
<o:p></o:p></span></font></p>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D3 width=3D"100%" align=3Dcenter>
</span></font></div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Don't just Search. Find! <a
href=3D"http://g.msn.com/8HMBENCA/2749??PS=3D47575">The new MSN Search: =
</a>Fast.
Clear. Easy. =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D 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. <o:p></o:p></span></font></p>
</blockquote>
</div>
</body>
</html>
------=_NextPart_000_0003_01C49D05.9CE46E70--