Solved

delay on aspx form after sql query execution

Posted on 2011-03-24
3
339 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:kahvedzic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Expert Comment

by:bitref
ID: 35209666
You may debug your code step by step (using F11) to be able to determine exactly the cause of the delay.
0
 
LVL 1

Accepted Solution

by:
kahvedzic earned 0 total points
ID: 35231021
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
 
LVL 1

Author Closing Comment

by:kahvedzic
ID: 35304189
Problem solved by myself.
0

Featured Post

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question