delay on aspx form after sql query execution

Hi,

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.
LVL 1
kahvedzicAsked:
Who is Participating?
 
kahvedzicAuthor Commented:
I dont know why but when I change Basic Settings->Pass-through authentication to Application user instead of Specific user it start to work like a charm without any delay. Thanks anyway for helping.

Cheers.
0
 
bitrefCommented:
You may debug your code step by step (using F11) to be able to determine exactly the cause of the delay.
0
 
kahvedzicAuthor Commented:
Problem solved by myself.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.