Solved

delay on aspx form after sql query execution

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

828 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