Solved

delay on aspx form after sql query execution

Posted on 2011-03-24
3
329 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
  • 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

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.…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now