DataSource Controls :: Sp Take Long Time To Execute?
May 22, 2010my sp take long time to execute. Why that?alter PROCEDURE [dbo].[sp_Util_DocPlanProgess21]
View 2 Repliesmy sp take long time to execute. Why that?alter PROCEDURE [dbo].[sp_Util_DocPlanProgess21]
View 2 RepliesThere 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?
Linq code sometimes takes too long to execute
View 4 RepliesI 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 RepliesI 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 Replieshow can i write a sql to execute the file at specific time sql server database.
View 3 RepliesI 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?
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[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.
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.
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 RepliesCurrently, 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)?
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 RepliesI 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.
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
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 RepliesFor 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.
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!
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
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 RepliesI 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]...
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
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 RepliesI 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 RepliesI 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