I am working for one in-house web application project with C#, ASP.NET and SQL Server 2005.
But here we are facing a issue for initial loading time of that application, it takes around 20 seconds to load it first time but after that it works fine,but again after 2/3 hours when we try to access same it is taking same long time.
I have tried all possible solution including optimization of code, indexing of tables and even asp.net pre-complication (aspnet_compiler.exe -v/ webapp name) on our deployment machine.
It is not even hardware issue as we have pretty high end servers as:
Code base deployment server
CPU Intel(R) Xeon 15160 @3.00GHz
Database Deplument server
CPU Intel(R) Xeon E5345 2.33GHz
Any resolution for that issue ?