DataSource Controls :: Linq Code Sometimes Takes Too Long To Execute
Mar 2, 2010Linq code sometimes takes too long to execute
View 4 Replies
Similar Messages:
DataSource Controls :: LINQ Query Takes Too Long To Execute?
Jun 6, 2010There 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?
DataSource Controls :: SQL Server First Full Text Search Takes A Long Time To Return Results?
May 19, 2010I 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 RepliesDataSource 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 RepliesADO.NET ::stored Proc That Takes A Bit Long To Run?
Aug 13, 2010I have a stored proc that takes a bit long to run. I tried to do this command.CommandTimeout = 200;still gets time out within 200 secs.How is this done?
View 1 RepliesWeb Forms :: Retrieving Image Takes Too Long
Apr 27, 2016Retrieving image from sql database, on pageload takes too long, sometimes 6-8 seconds long. That is too much time to retrieve a binary file and display it on image button. How can I retrieve image in just 2 seconds?
View 1 RepliesPopulating Droplist With SQL Server Takes A Long Time?
Jan 19, 2010One of my web pages populates a droplist with about 60k items pulled from SQL Server, and this operation takes upwards of 10 seconds to complete. Are there some tricks or optimizations I can try to improve performance? I'm using a SqlDataSource configured as a DataReader.
View 5 RepliesForms Data Controls :: Web Application Project Performance Takes Long To Load Data
Dec 13, 2010I there I have recently created an ASP website wich uses .net 4 and SQL db but soem some reason even displaying 20 records in a gridview is slow... So after some reading I converted the website to a Web Application Project so its compile prior to publish.. But yet again this is a bit slow. pages loading time is not of a bit issue...
View 8 RepliesWebsite Takes A Long Time To Start After Solution Build?
Apr 4, 2011In development, our Asp.Net 4 website takes a fairly lengthy time to start after the project libraries are built
We do a fair amount of population of statics etc, but not enough to justify the length of time it takes the app to come up (probably 3-4 minutes)
We aren't building the website, just the libraries, and batch != true in the compilation element in the .config file.
I will try log some diagnostics, but any other pointers would be useful
Visual Studio :: Browser Refresh Takes A Long Time
Mar 9, 2011Project
I'm running a single page (default.aspx) web site in Visual Studio 2010. I have a few other projects in the solution, but they're all taken out of the build queue at the moment. I'm using Visual Studio Development Server as the web server (I haven't tried IIS yet). I'm using the HTML5 Boilerplate from [URL] I'm testing in Chrome and IE8
Problem
Visual Studio 2010 is outputting "Debug" information to the Output window every time I refresh my browser. Whilst this isn't a problem in itself, it seems to be extremely slow in doing so... it takes around 4 seconds to show the page in full from initial refresh.
I've noticed that the "Script Documents" folder appears in my solution view, and some files (notably JS files) seem to take a while to show up. I've tried removing all the JS and CSS file references from my page, but it still does it.
So, to troubleshoot I've created an index.aspx page with no content apart from the generic ASP.Net template code, set this as the start page, but it still takes just as long to load up as the other page.
As a last resort, I've created a new project and tried it with no changes to the default page - still the same, takes a few seconds to finish loading in either browser.
The strange thing is that this happens even when I stop debugging in Visual Studio and browse directly to the URL on the ASP.NET Development server.
Output Windows contents when page is refreshed
[Code]....
Stop Debugging Web Application On IIS In VS2010 Takes Long Time?
Jan 3, 2011Whenever I stop debugging an ASP.NET IIS web application it seems to take very long before VS2010 becomes responsive again (2 or 3 minutes). This happens when I close Internet Explorer 9 (which stops the debugging session), stop debugging in VS (which closes the browser) or when I detach the debugger from the debugging menu (which leaves the browser open).
My CPU time for devenv.exe goes up to 25% during this period of time. I use the professional edition (no intellitrace). Starting without debugging performs ok when I close the browser. I have some add-ins and extensions installed like TestDriven.NET, Resharper, PowerCommands, Productivity Power Tools, VisualSVN,...
Visual Studio :: Checkout/Checkin Takes A Long Time?
Jul 27, 2010Checkout/Checkin takes a long tim
View 1 RepliesWeb Forms :: Improve Performance - Takes Long Time To Save Data
Mar 8, 2010I have selected around hundred data and then bind to the repeater each times it take a long time to save data after clicking the save button. How can i improve the performance?
View 6 RepliesDatabases :: Takes A Lot Of Time To Execute A Query?
Dec 14, 2010I have table for past four years. It had a records for around 10 Lacks it was taking lot of time to execute so i removed recordes from the table. Table size was reduced to 29 thousand. Still when i execute a query from my application it takes more than 2 minutes to return.
View 4 RepliesDataSource Controls :: LINQ DataContext From Code Behind?
Jan 21, 2010I have a linq DataSource and a Grid in my htnl and I want to access the DataContext from code behind. Now in the past when I do evrything in code behind I just use...
DataContextName db = new DataContextName();
and I have my reference.
Now I can still do that and it works fine it just seems odd to be making a second class object when there is one that is made from the linq DataSource in the html. But I can't figure out how to get a reference to the DataContext that is created from my html code.
DataSource Controls :: Convert Code Of SQL To Linq?
May 14, 2010I would like to ask the programmers to help me in C# with LINQ to SQL.
I have this code conn.Open();
SqlDataReader dr = DB.ExecSpReader("select AttachmentName from AttachmentTable where TicketId=" + ticketID, param);
while (dr.Read())
{[code]....
and I need to convert it to LINQ SQL.
Visual Studio :: Saving Aspx File In Source View Mode Takes Too Long?
Jun 30, 2010saving my aspx file takes too long, it has some nested tables, but it is nothing huge, it has like 50+ overall controls on the form. When I hit the save button, it takes a few minutes and drives cpu crazy, so I am guessing it is doing something in the background.
So, what is the reason, any clues how to speed this up?
I am using Vs.Net 2010 Ultimate
HttpHandlers / Modules :: Cache Images - Page Takes To Long Due To Images Not Caching?
Mar 31, 2010I've been trying to get image caching working for the last 8 hours and I keep the same problem time and time again, I'm trying to cache Images at the moment and then when thats succesful, apply this to cache my js and css files. I have at the moment Sql Dependancy caching working on my dynamic pages but the page still takes to long due to images not caching.
What I have tried is going to IIS7 Management and adding HTTP Response Header for the images folder and setting various things for the cache control.i dont care how long it caches it on the client or on the proxy servers i just would like it to check when the file was modified and compare it with the one in the client or proxy cache and if they are different then fetch the new image which has been ftp up. i could solve this by changing the image name but the thing is the image name is generated when they are ftp'd to the site by an application and the name is a direct reference to the product so i cant change the name each time, as it would mean making a lot of otherpages accross the board.
so What i would like, is to set and expiry date of lets say 32 days or more on the images and then check to see if they have changed by date modified or some other way of checking(Etags maybe) I'm not sure, if they have changed on the server then redownload and recache them, I tried using post-check and pre-check together but that just permantly cached them, so when i change the image the only way it would display the new image is to just hit F5.
In Brief, how can i Cache images, on the client machine/ proxy cache and recache them when the modified date of the file has changed.
AJAX :: Trying To Create A Progress Bar For Page Load As It Takes Long To Load?
Jul 7, 2010I am trying to create a progress bar for page load as it takes long to load. I need help to resolve jscript error 'null' is null or not an object on line $get("btn").click();
[Code]....
AJAX :: Execute Animation On An Asp Button That Has To Execute Code On Postback?
Feb 15, 2011I'm trying to understand how to execute AJAX animation on an asp button that has to execute code on Postback. In other words, I have button with code behind that needs to be excuted, but at the same time want to be able to have one of animation extenders be applied to it. I understand that I need to use the BeginRequest Event, I'm just not sure how, or which javascript commands to use to call the ajax animation so the postback will still occur.
View 5 RepliesDataSource Controls :: The SQL Below Takes At Least 7 Second To Run And May Even Time Out?
May 6, 2010The SQL below takes at least 7 second to run and may even time out.
There are a lot of records over a million in each of the two tables being inner joined and then being searched on.
I have tried putting an index on the create_date# and rdat# hoping that sql would not have to access all the records
But it seems to have made no difference, so I have now deleted those indexes.
I realise that manipulation of strings comes at a price but I can only work with the data I have been given.
Do you have any tips or trick that I can use to optimise this code?
-- Description: Finds all customer infomation that matches at least two params
-- =============================================
ALTER PROCEDURE [dbo].[usp_FindMatchesInDAProspect.bak] [code]....
Web Forms :: Webpage Takes Long Time To Load For The First Time?
Apr 30, 2010I 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?
Login Page Takes Long Time To Login?
Apr 12, 2010I am working on a web application in C#. I am using FormsAuthenticationTicket to authenticate the user. The user's information is check against a sqlserver database, if the correct credential is entered, (combine the username and password, encrypt them using the FormsAuthentication, and assign the random number generated to a session.), the users is redirected to a welcome pages.
However, I notice that there are times when I run the application, and it takes over five minutes to display the login screen, or I have to stop and start the application in order to display the login screen . Does anyone have an idea what may cause this issue?
DataSource Controls :: SelectCommand String Is Too Long?
Dec 21, 2010My 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 RepliesDataSource Controls :: Breaking Long Query Into Small One Using SQLDataSource?
Oct 25, 2010Currently, 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)?