Here's the long story short. At work we have to real-time generate a report(excel format) which involves a number of table joining. So to export into excel contentType 'application/vnd.ms-excel' is used, and data are written as table, looping each row of recordset data as table row. Problem is when user hit export and attempt to open/save the file, file would then be downloaded at constant rate. But during this time, entire server would be irresponsive and in a hang-like state, this is expereinced by all users. When they attmept to visit another asp page they would wait until the page eventually timeout. This will continues until the report was completely generated and downloaded by users. I'm not sure if i'm explaining myself clearly here but I appreciate all the helps I can get. Thanks.
"Newbro" wrote in message news:2E48E6AB-580B-49A5-A562-7A300A36A2C9@microsoft.com... > Here's the long story short. > At work we have to real-time generate a report(excel format) which involves > a number of table joining. So to export into excel contentType > 'application/vnd.ms-excel' is used, and data are written as table, looping > each row of recordset data as table row. > > Problem is when user hit export and attempt to open/save the file, file > would then be downloaded at constant rate. But during this time, entire > server would be irresponsive and in a hang-like state, this is expereinced by > all users. When they attmept to visit another asp page they would wait until > the page eventually timeout. This will continues until the report was > completely generated and downloaded by users. > > I'm not sure if i'm explaining myself clearly here but I appreciate all the > helps I can get. Thanks. I'm not entirely sure whether you mean that: a) when a user downloads the spreadhsheet that user can not navigate the site whilst the down load is in progress. OR b) when one user downloads the spreadsheet all users can not access the site If (a) then this is a limitation of ASP which can on process one script per session at a time. The users session is currently involved in a script generating the spreadsheet so any further requests for ASP pages will have to be queued until the script completes. If (b) then you have ASP Debugging turned on which means that only one thread is used to process ASP requests hence whilst the spreadsheet script is running no other ASP script for any user can be processed. In IIS open the properties dialog on the application on home directory tab click Configuration. In the Application Configuration dialog select the App Debugging tab and unselect the Debugging flags. -- Anthony Jones - MVP ASP/ASP.NET
Anthony Scenario B is exactly the situation. I followed your advice to turn off the script debuging and Bam! All problems gone! You don't know how much times you saved me from trying to solve this issue :) Only thing is that I thought stuff like this should really be turn off by default. Anyway really thanks a bunch. "Anthony Jones" wrote: > "Newbro" wrote in message > news:2E48E6AB-580B-49A5-A562-7A300A36A2C9@microsoft.com... > > Here's the long story short. > > At work we have to real-time generate a report(excel format) which > involves > > a number of table joining. So to export into excel contentType > > 'application/vnd.ms-excel' is used, and data are written as table, looping > > each row of recordset data as table row. > > > > Problem is when user hit export and attempt to open/save the file, file > > would then be downloaded at constant rate. But during this time, entire > > server would be irresponsive and in a hang-like state, this is expereinced > by > > all users. When they attmept to visit another asp page they would wait > until > > the page eventually timeout. This will continues until the report was > > completely generated and downloaded by users. > > > > I'm not sure if i'm explaining myself clearly here but I appreciate all > the > > helps I can get. Thanks. > > I'm not entirely sure whether you mean that: > > a) when a user downloads the spreadhsheet that user can not navigate the > site whilst the down load is in progress. > > OR > > b) when one user downloads the spreadsheet all users can not access the > site > > > If (a) then this is a limitation of ASP which can on process one script per > session at a time. The users session is currently involved in a script > generating the spreadsheet so any further requests for ASP pages will have > to be queued until the script completes. > > If (b) then you have ASP Debugging turned on which means that only one > thread is used to process ASP requests hence whilst the spreadsheet script > is running no other ASP script for any user can be processed. In IIS open > the properties dialog on the application on home directory tab click > Configuration. In the Application Configuration dialog select the App > Debugging tab and unselect the Debugging flags. > > > -- > Anthony Jones - MVP ASP/ASP.NET > > >
"Newbro" wrote in message news:2E48E6AB-580B-49A5-A562-7A300A36A2C9@microsoft.com... > Here's the long story short. > At work we have to real-time generate a report(excel format) which > involves > a number of table joining. So to export into excel contentType > 'application/vnd.ms-excel' is used, and data are written as table, looping > each row of recordset data as table row. > > Problem is when user hit export and attempt to open/save the file, file > would then be downloaded at constant rate. But during this time, entire > server would be irresponsive and in a hang-like state, this is expereinced > by > all users. When they attmept to visit another asp page they would wait > until > the page eventually timeout. This will continues until the report was > completely generated and downloaded by users. > > I'm not sure if i'm explaining myself clearly here but I appreciate all > the > helps I can get. Thanks. Have you considered importing the data directly from Excel? This would eliminate the need for IIS/ASP to act as an intermediary. Also, if the data is summarized in Excel, you may want to consider performing the summary in the database to limit the data that needs to be sent.
