delay on aspx form after sql query execution
Posted on 2011-03-24
I have aspx form that presents data from sql server, after select execution in code behind I filter data and do some calculation for presenting data on form. This select executes every minute, and form reloads each minute. Depending on results image button picture changes and sound notification plays. In some cases this action is delayed (some time for 3-5-10 even 30 minutes), why is this happening, could problem be in size of query and its results, or it might be in app pool settings? I dont know and have no idea, so any help would be appreciated.
For this web page I use Framework 4, VS 2010, MS SQL Server 2008 and MS Win server 2008 32bit. Application pool managed pipeline mode is classic.
Thanks for all effort.