How to free the my application server memory?!
-
Hi, I'm involved in the development of a web application for a huge organization. The web applications are developed with VS.NET 2003 with oracle DB and IIS for the webserver. We have the problem that the database has huge ammount of data and the application has to be an online one so we can't work in offline mode. The application may load some data in the application server memory for sometime but once the user finished what he wants, I should remove these data from the memory, but the ADO.NET cashes the data and I don't know how to free it. I tried to dispose all the objects but no effect. NOTE: The data is huge that we have a table that may contains about 700000 records and increasing by the time. This problem causes the application server to fall down by the time and I have to restart the IIS to free the memory. If the declartion of the problem is not clear please contact me eng_amahmoud_fcis@hotmail.com or ayman.mahmoud@gmail.com Thanks. Ayman Mahmoud
-
Hi, I'm involved in the development of a web application for a huge organization. The web applications are developed with VS.NET 2003 with oracle DB and IIS for the webserver. We have the problem that the database has huge ammount of data and the application has to be an online one so we can't work in offline mode. The application may load some data in the application server memory for sometime but once the user finished what he wants, I should remove these data from the memory, but the ADO.NET cashes the data and I don't know how to free it. I tried to dispose all the objects but no effect. NOTE: The data is huge that we have a table that may contains about 700000 records and increasing by the time. This problem causes the application server to fall down by the time and I have to restart the IIS to free the memory. If the declartion of the problem is not clear please contact me eng_amahmoud_fcis@hotmail.com or ayman.mahmoud@gmail.com Thanks. Ayman Mahmoud
- If you are caching the data see that you put the timeout as well. 2) If you running IIS 6. Schedule the appliaction pool restart periodically. 3) If you have lot of data cosider using s staging DB or table to store the most frequently accessed data.
Thanks Laddie Kindly rate if the answer was helpful
-
- If you are caching the data see that you put the timeout as well. 2) If you running IIS 6. Schedule the appliaction pool restart periodically. 3) If you have lot of data cosider using s staging DB or table to store the most frequently accessed data.
Thanks Laddie Kindly rate if the answer was helpful
Hi, I'm running IIS 6, but is this problem can be solved with IIS 7 in another manner rather than restarting the IIS, because restarting the IIS will cause the user not to be able to browse the application site during the restarting process and this may cause problem due to the business enviorment in which the application is running. Ayman Mahmoud