Link to home
Start Free TrialLog in
Avatar of kahvedzic
kahvedzicFlag for Bosnia and Herzegovina

asked on

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.
Avatar of bitref
bitref
Flag of United States of America image

You may debug your code step by step (using F11) to be able to determine exactly the cause of the delay.
ASKER CERTIFIED SOLUTION
Avatar of kahvedzic
kahvedzic
Flag of Bosnia and Herzegovina image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kahvedzic

ASKER

Problem solved by myself.