ASPNET Worker Process Recycled?!
I received a ad-hoc task for retrieving, sorting and filtering data from a Excel file tonight, it's pretty simple and straighforward - Just use an appropriate connectionString in ADO.NET then I can connect to the 'data source' and manipulate the data directly.
However, I 'hang' for about 5 minutes in front of my workstation in the process! There're two problems which were sucking me:
1. A Excel worksheet was used as a Data Source by user, well, I understand this situation as users are more familiar with the Office products sense, but the point is that the single worksheet contain >= 20Mb of data, which take me l..o..n..g.. time in loading. 20Mb is a insignificant size when storing in a SQL Server, but loading up a 20Mb Excel file is really face a heavy performance penalty. (More info: The file is connected and filled with data from a SQL Server, but I'm not authorized to access to this Server directly, don't laugh at me)
2. An error message with something like "aspnet worker process recycled" displayed when I was retrieving the data from the 'data source'. Next, I go to open up my Event Viewer and see what's going on. The reason is something like "Insufficient memory - the ASP.NET process take > 60% of my physical memory". Ah.... I have 256Mb physical RAM in my workstation and... I don't want to waste time in this issue but just search and scan a similar Kb from Microsoft support site.
Finally, my solution is to break down the amount of data to be SELECT for retrival in order to 'avoid' this problem, I don't want to spend more time in investigating or trying to solve this problem tonight, as I want to completed my task ASAP and off - I've stayed in office for nearly 12 hours already.
Inproper way for problem-solving and learning? or reply to user in the shortest response time? Who win? Excel or XML or other Data Source will you suggest to users?