RE: Database to Excel

Charles,

I am writing the files to a directory in /Root. Then I end up copying
it to QDLS in order to send it. I did that when I initiated this
project.


Sharon Wintermute

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, November 19, 2008 6:52 AM
To: Midrange Systems Technical Discussion
Subject: Re: Database to Excel

But the RPG/Java is writing to the /QDLS file system correct?

Try writing someplace else and see if it makes a significant difference.

Charles

On Tue, Nov 18, 2008 at 5:25 PM, Wintermute, Sharon <
Sharon.Wintermute@xxxxxxxxxxxxxxxx> wrote:

Its not the SNDDST eating up the time, it's the actual RPG - Java call
that seems to be slowing it down. I intend to get rid of QDLS as

well,

its just not as high a priority.


Sharon Wintermute

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Tuesday, November 18, 2008 4:12 PM
To: Midrange Systems Technical Discussion
Subject: Re: Database to Excel

Sharon,

You might try getting rid of the use of SNDDST and using a file system
besides QDLS.

The performance of QDLS is very, very poor.

You can look in the archives for alternatives.

Charles

On Tue, Nov 18, 2008 at 4:57 PM, Wintermute, Sharon <
Sharon.Wintermute@xxxxxxxxxxxxxxxx> wrote:

I have a question. I recently used Scott Klement's Excel articles

to

create an Excel processor. It uses a control file that describes

what

file, what Excel worksheet to use as a base, then adds the data to a

new

copy of the worksheet. Once this is done, another job actually

sends

the file from the IFS to the user. I had to separate the creation

and

the sending since SNDDST only uses QDLS and QDLS cannot be used in a

job

where Java is involved (multi-threading).



The process itself works great. It runs every 10 minutes looking

for

new requests to process. Now we have discovered that some of these
requests are huge files. Over 75K rows to be created. This one

request

ran for over 45 minutes on a usually lightning box.



This lpar has over 8 gig memory and its on a M525-7792 so its

usually

a

speed demon.



I really need to decrease the time significantly. Any ideas? Is

there

another way to do this, perhaps without Java?





Sharon Wintermute



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.