ASP, Excel -Size and memory

[mamun]

Hi All,

I have an asp page that displays the results in Excel in the browser.
It has about 40 columns and sometimes records can grow upto 1100.

For small number of records I do not get any error messages or displays
the result in Excel format properly. But for the higher number of
records even if the program runs for all day it hangs up and shows
nothing.

In the asp program I have many if and then statement as well as big
loop.

My question is how can I solve this problem? Do I have to look into the
web server memory and other configuration settings? Or is there a
maximum size limit in Excel.

I do highly appreciate your help.

Thanks a ton in advance.
Best regards,
Mamun

 

[Anthony Jones]

Hi All,

I have an asp page that displays the results in Excel in the browser.
It has about 40 columns and sometimes records can grow upto 1100.

For small number of records I do not get any error messages or displays
the result in Excel format properly. But for the higher number of
records even if the program

What program?

runs for all day it hangs up

Isn't that an oxymoron does it run or does it hang?
If it 'runs' how do you know it is 'running'?
Do you know whether the server is doing something?
If so is it gobbling up a lot of CPU?

and shows
nothing.

do you mean it never shows anything because it's hung or is still running
and hasn't returned anything?

In the asp program I have many if and then statement as well as big
loop.

My question is how can I solve this problem?
Do I have to look into the
web server memory and other configuration settings? Or is there a
maximum size limit in Excel.

What server are you using. There is a default buffer limit on IIIS6 of 4MB.