Optimize Excel Download

[Former Member]

i have this program to optimize.

months before, it was just a simple program that displays report through a couploe of WRITE statements.

later, somebody was given a task to download the output into an excel file.

it was done BUT, it runs toooooooooooo slow now.

for 20 employees, the program runs for more than 22 minutes.

i was now assigned to optimize the program.

now it runs 5 minutes for 20 employees processed.

i am not satisfied.

not at all.

coz in production, thousands of employees may sometimes be processed.

what advise can you guys give me on these kind of matters: excel downloads.

the only thing i did right now is not rewrite the program but i just added "NO FLUSH" in some of the OLE calls. then i called the function "FLUSH" at the end. 22 minutes down to 5 minutes (on 20 pernrs) is a big improvement but that is just not acceptable, still.

any advise would be appreciated. tnx.

[Former Member]

i have this program to optimize.

months before, it was just a simple program that displays report through a couploe of WRITE statements.

later, somebody was given a task to download the output into an excel file.

it was done BUT, it runs toooooooooooo slow now.

for 20 employees, the program runs for more than 22 minutes.

i was now assigned to optimize the program.

now it runs 5 minutes for 20 employees processed.

i am not satisfied.

not at all.

coz in production, thousands of employees may sometimes be processed.

what advise can you guys give me on these kind of matters: excel downloads.

the only thing i did right now is not rewrite the program but i just added "NO FLUSH" in some of the OLE calls. then i called the function "FLUSH" at the end. 22 minutes down to 5 minutes (on 20 pernrs) is a big improvement but that is just not acceptable, still.

any advise would be appreciated. tnx.

[Former Member]

Hi,

Instead of ole , you Create a job for downloading of program.So how much time it will take it won't be problem for u. OLE applications will obviously more time because they need to interact with 3rd party tool.

[Former Member]

hi subas bose,

i didn't quite get what you mean.

could you rephrase your words?

if i don't use ole, how do i do the excel download?

tnx,

laure