sridhar1985
New member
- Joined
- Jul 7, 2008
- Messages
- 1
- Programming Experience
- 3-5
Dear All,
I am in the process of developing an application for one of my clients. I am not going into the details of the applications, but brief facts of the same. The application is divided into two tiers (actually three, but the third tier is the database (SQL SERVER) so that is not included). The top tier (or first tier) is a web application (ASP.NET) where the users shall log into the system and use the application. This web application will also access the Database directly. One important activity the users shall do is uploading excel files with various information to the server. Web Application once the upload is successful shall enter the details in the in Database about the upload along with an ID and save the excel file at a location in the server.
The Second tier is a VB.NET Application which will run in the server. The application will connect the database and retrieve the list of excel file uploaded by the web application and start processing one excel file after another based on ID. The processing that will be done is very simple: read the excel file, check for certain parameters, do some calculations and insert the whole details into the database. (say some 100 records per excel file)
The server in which the VB.NET Application (Second tier) runs is hosting a serious of services and application which shall run simultaneously including the Database (SQLSERVER), web server. The Database also host tables and database for various other applications.
In order to help in the smooth functioning of the system, it has been decided that the VB.NET shall do the processing activity only when the server is idle (including CPU usage is idle). I have searched the Net and found API to get the system Idle status. But the real question is how to pause the processing activity when the system switch from idle mode and continue when it is again back to idle mode. Please note that I am talking about system being idle because no other application is executing any activity except the VB.NET Application.
Request you give suggestions and ways and means to achieve the objective.
Thanks and regards,
Sri
I am in the process of developing an application for one of my clients. I am not going into the details of the applications, but brief facts of the same. The application is divided into two tiers (actually three, but the third tier is the database (SQL SERVER) so that is not included). The top tier (or first tier) is a web application (ASP.NET) where the users shall log into the system and use the application. This web application will also access the Database directly. One important activity the users shall do is uploading excel files with various information to the server. Web Application once the upload is successful shall enter the details in the in Database about the upload along with an ID and save the excel file at a location in the server.
The Second tier is a VB.NET Application which will run in the server. The application will connect the database and retrieve the list of excel file uploaded by the web application and start processing one excel file after another based on ID. The processing that will be done is very simple: read the excel file, check for certain parameters, do some calculations and insert the whole details into the database. (say some 100 records per excel file)
The server in which the VB.NET Application (Second tier) runs is hosting a serious of services and application which shall run simultaneously including the Database (SQLSERVER), web server. The Database also host tables and database for various other applications.
In order to help in the smooth functioning of the system, it has been decided that the VB.NET shall do the processing activity only when the server is idle (including CPU usage is idle). I have searched the Net and found API to get the system Idle status. But the real question is how to pause the processing activity when the system switch from idle mode and continue when it is again back to idle mode. Please note that I am talking about system being idle because no other application is executing any activity except the VB.NET Application.
Request you give suggestions and ways and means to achieve the objective.
Thanks and regards,
Sri
