DataSource Controls :: Sp Take Long Time To Execute?

May 22, 2010

my sp take long time to execute. Why that?alter PROCEDURE [dbo].[sp_Util_DocPlanProgess21]

View 2 Replies


Similar Messages:

DataSource Controls :: LINQ Query Takes Too Long To Execute?

Jun 6, 2010

There is a table contains thousands of records. when I run this query:

[Code]....

The application stucks...it takes too much time to execute this query...

What might be the reason for that?

View 7 Replies

DataSource Controls :: Linq Code Sometimes Takes Too Long To Execute

Mar 2, 2010

Linq code sometimes takes too long to execute

View 4 Replies

DataSource Controls :: Taking Long Time To Import Data From Csv To Sql Server 2005?

Feb 20, 2010

I have an application which imports data from csv to sql server 2005. It is taking long time to import data from csv to sql server 2005. it has a timer. on tick of timer, I am checking if current rown in csv exists in database. If it exists, It is not added to sql server otherwise, It is added that row to sql server 2005. Also, In page load, It checks on each tick, whether user is logged in or not. it adds value to log file that user is logged in. How can I optimize this ?

View 1 Replies

DataSource Controls :: SQL Server First Full Text Search Takes A Long Time To Return Results?

May 19, 2010

I am working on a website hosted with GoDaddy, SQL Server 2005. I have a table in my SQL Server database with a full-text index. On my website, a user can type in search terms and the terms are then passed to a stored procedure in the database which performs the search. The first search takes about 45 seconds to get results. Subsequent searches return results immediately. I found a description of this problem in a Microsoft knowledgebase article:http://support.microsoft.com/kb/915850/en-usGoDaddy tech support says I need to purchase a dedicated server to make the changes suggested in this article.Surely there is some other solution. Does anyone know how to avoid this delay without changing the server configuration?

View 1 Replies

DataSource Controls :: How To Write A Sql To Execute The File At Specific Time Sql Server Database

May 28, 2010

how can i write a sql to execute the file at specific time sql server database.

View 3 Replies

Web Forms :: Webpage Takes Long Time To Load For The First Time?

Apr 30, 2010

I am working on a ASP.NET 2.0 application. It is hosted on IIS 6 on Windows 2003 server.

Few pages have jpeg images (around 50 images and 50 KB each). It takes long time to load the page for the first time. But when i open the same page for the second or third time it is faster.

why does a web page take long time to load for the first time?

Is it cached somewhere when it loads for the first time? Do we have any control over it?

View 5 Replies

Crystal Reports :: Each And Every Page Loading Time And Where Actually It Take Long Time?

Nov 22, 2010

I have developed an application in asp.net with crystal report. It has more than 30 pages in the project. Now I want to improve the performance of the application.1. What I need is , I want to know each and every page loading time and where actually it take long time to load while requesting the page.There are so many tools available. But am not able to follow as where actually the problem is and how to solve.

View 6 Replies

Forms Data Controls :: Aspx Page Is Taking Long Time To Load Controls (repeater)

Feb 12, 2011

[Code]....

I am retrieving records from database nearly 380 records and binding them to a repeater control.My page is taking long time to load. how to improve the performance and here is the code of my repeater.

View 1 Replies

Data Controls :: Every Post Back In Form Is Taking Long Time When Several Update Panels Used

Nov 22, 2015

I have a big form in which i have almost 10 update panels. some are having updatemode = conditional and others are always. Now by default when that page is opened i only show one dropdownlist.When that project dropdownlist (from which i populate the rest of the elements in my page) value is changed by user it takes long time to load the other elements. Also the other gridview which is also surrounded by update panel and mode in conditional takes long time to show edititemtemplate controls in edit mode. 

I am unable to trace the reason behing delay. Few days ago it was working fine and fast but now it is slow.

View 1 Replies

DataSource Controls :: SelectCommand String Is Too Long?

Dec 21, 2010

My SelectCommand string in my asp:SqlDataSource is very long. Is there a way I can chop it up into different strings on several newlines to make it more readable?

View 4 Replies

DataSource Controls :: Breaking Long Query Into Small One Using SQLDataSource?

Oct 25, 2010

Currently, I have long script which does major processing and then puts data into temp table.

Finally I read data from this temp table to show on the chart, based on user's selection of parameter. So I can divide my query into two parts and while I am researching this,

Is it possible to do processing in one Datasource and read table from second datasource?Is it even possible?

If not, what is recommended method for this (breaking large processing into small one)?

View 2 Replies

DataSource Controls :: Calling Long Running SQL Procedure From UI - Workaround?

Jun 16, 2010

I have a site that calls a long running stored procedure that eventually times out the UI. The procedure simply runs some logic in the database, and kicks of a secondary process. No data is ever returned to the UI, so I don't need the UI to wait for anything.Is there a way to call the stored procedure from the UI and move on without having the UI having to wait for the store procedure to complete?

View 4 Replies

Forms Data Controls :: Ajax In Asp 1.1 / Taking Too Much Refresh And Taking Long Time?

Jan 13, 2010

I am making some application in asp.net 1.1 in that I am displaying data in datagrid from database. In data grid first column is of check box and radio button and in the last column we have text box now thing is that when i click on check box crosponding textbox we fill some figure and at the end we press calculate button to get total. After getting total we have to press continue button to go next step

But suppose if some body remove that check the we should press calculate button or chnage some figure in the text box then we should press calculate button again to recalculate. for that i kept autopost back on check box oncheckedchanged event and text box ontextchanged event and hide continue button so user will click calcutae button abd then continue button will re-apper

Problem it that it taking too much refresh and taking long time. So was lloking for some ajax method to use in my application.

View 8 Replies

DataSource Controls :: Can Execute DTS Using C#

Mar 15, 2010

I use the code in [URL] to execute DTS in ASP.NET as following

[Code]....

but it always fire the OnQueryCancel event, I don't know why

I used the main code for firing the DTS , it check the hlobal variable and when reach the line

package.Execute(); it fire OnQueryCancel event ;

I tried alot of techniques but all of them failed

View 2 Replies

Why Does IIS7 Take A Long Time To Configure

Oct 7, 2010

It looks likes if I don't visit my low traffic site for a day, it takes a long time for the first page to load. I believe it's probably because IIS7 shuts down the application when it receives no requests for a certain length of time. I have a dedicated server so I have all the access required to change things in IIS

View 3 Replies

C# - Long Time To Load First Sql Connection In .NET?

Apr 9, 2010

For some reason it takes 7 seconds to open a connection to a sql server database for the firt time, subsequent connections takes a second.

I'm using C# and asp.net

Its after compilation, i essence every time i restart the site, which means every time it needs to actualy create the "first" connection. i understand that setting up connection pooling has overhead, but i have never seen that i should take 7 second to set it up.

View 3 Replies

DataSource Controls :: MS SQL Management Studio 2008 - Waiting Very Long For DB - Tree

Mar 22, 2010

I installed MS SQL Express 2008 with Advanced Services including Management Studio 2008. When I connect to the SQL server of my provider (shared hosting - one SQL server for many customers), it takes very long (up to serveral minutes) until all DBs are displayed in the object explorer (from which I then have to choose my DB). Somebody told me, the long waiting time occurs because Management Studio first checks rights (whichever rights that may be) with every DB that runs on the server.

But in Management Studio 2005 the behaviour is different - the DB Tree in the object explorer expands immediately! No waiting time! Does anyone know a solution for this? I don't want to install two separate versions of Management Studio just because of that!

View 1 Replies

MVC - Images Taking A Long Time To Load?

Oct 4, 2010

I have tested my pages in Firefox & IE and looking at Firebug in Firefox for some reason some images are taking a long time to load. They are not very big in comparison to the ones which are loading quicker.

Attached is a screenshot of Firebug.

I especially notice it in IE with the progress bar at the bottom of the page, it just sits there saying loading image...

Could it be the path or something which is http://localhost:49211/Content/_layout/images/bg-footer.png for example

View 2 Replies

Configuration Take Long Time To Upload The Application?

Jun 9, 2010

We deplyed an application to a host, my default asp.net page load 3 small catalogs, this delay to load about 15 secondsthe first time, Can I do something about it

View 1 Replies

Ajax CalendarExtendar Take Long Time To Load?

Apr 15, 2010

I have a web page which has a textbox and a button. The textbox has a calendar extender attatched to it.On my machine it is popup quickly but when i published it on the server it's taking a very long time to show and sometimes it doesn't. It's like loading or downloading something. Any Clues .....

asp:TextBox ID="txtDateFrom" runat="server" CssClass="TxtBoxDate" meta:resourcekey="txtDateFromResource1"></asp:TextBox>
<ajax:CalendarExtender ID="extCalendarStartDate" runat="server" CssClass="calTheme" Format="yyyy/MM/dd" FirstDayOfWeek="Sunday" PopupPosition="BottomRight" TargetControlID="txtDateFrom" OnClientDateSelectionChanged="checkDate" Enabled="True"> </ajax:CalendarExtender>
[code]...

View 2 Replies

Web Forms :: Web Page Not Getting Displayed For A Long Time?

Jul 26, 2010

i have a web aplication in asp.net 2.0. i have configured it using IIS when i am trying to access the webpage even thr' the IIS , the page is not getting displayed.there is no error msg nor any msg , but nothing appears even for a very long timethe webapplication was wrking fine 2 days back

after nearly 5 mts i get a msg Thread was being aborted. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Threading.ThreadAbortException: Thread was being aborted.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ThreadAbortException: Thread was being aborted.]
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +486
System.Web.ApplicationStepManager.ResumeSteps(Exception error) +501
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) +123
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +379

Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

View 4 Replies

Configuration :: Site Take A Very Long Time To Load?

Mar 26, 2010

i developed a website already and it was hosted in live too. My Problem is , site take a very long time to load , it take nearly 30-60 seconds to open , once it opened then it is some what better, MY Url Ishttp:\shoesrus.msinternational.bizplease verify and give me a solution , is their is any setting changes has to be taken in iis or server side etc..

View 3 Replies

Web Forms :: How To Keep User Logged In For Long Time

Aug 20, 2013

I want to implement user login function , that allow user to login after couple of weaks without asking username and password again. I have read many article and got that it is maintain by Cookie but don't know how to implement this one. A good example is seen in gmail, facebook [URL] .... that allow user logged in for couple of weaks. I also want to maintain a cookie table for just keepig the records of user logged in from different system. 

View 1 Replies

Web Forms :: Session Is Not Alive For Long Time

May 14, 2012

I have used session in my application for admin panel. It is redirecting if i not use 1 or 2 minutes. I need to stay session until I click logout  button.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved