Debug With Differing Execution Times In Different Contexts
Mar 17, 2010
The following question seems to be haunting me more consistently than most other questions recently. What kinds of things they look for when trying to debug "performance issues" like this?k, get this - running this in query analyzer takes < 1 second
i am using sql server inbuilt mail system for sending mail.and i made SP to call dbmail sp
now my problem is when i call sp it get executed fine but in last suppose 1000 mails queued then 1000 times i get mail queued.and that my connection time out .i extend connection time out limit but i get error msg like
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Mail queued."
my mail get queued well proper but due to 1000 or 100000 mail queued its lost of msg make problem.
I want to debug EditPanel.debug.js file of HTML Editor, but it never shows in VS 08 and Im sure it executes to that line.What I did to enable debuggingUnchecked both 2 checkboxes for disabling the debugging
Set ScriptMode="Debug"
Change following line
[ClientScriptResource("AjaxControlToolkit.HTMLEditor.EditPanel", "AjaxControlToolkit.HTMLEditor.EditPanel.js")] to [ClientScriptResource("AjaxControlToolkit.HTMLEditor.EditPanel", "AjaxControlToolkit.HTMLEditor.EditPanel.debug.js")]
I'm trying to get the current action method by this way.
ActionDescriptor actionDescriptor = filterContext.ActionDescriptor; string actionName = actionDescriptor.ActionName; var controllerType = filterContext.Controller.GetType(); var actionMethod = controllerType.GetMethod(actionName);
But if there're two action method with the same name, the AmbiguousMatchException will occur there. Without the ActionMethod property, how can I get the current action method now?
As a new developer I'm getting thoroughly confused by naming and structural conventions for developing c# code using best practice.I appreciate it's perhaps applicable to each domain I am developing for but I've seen the code of many different open source projects and there seems to be a common theme. The successful projects have well thought out structure for maintenance and extensibility.The terms context, service, repository and controllers are used often and I wondered if these are open to interpretation or is there a consensus or convention on what, where or how these get used.
In an e-commerce platform I've seen there are order services, order contexts, customer repositories and product controllers for example. What should they do based on these names? Does a controller do something different to a service? When should you use a context? Is there a convention for namespaces? It's mind boggling when you try and push from a spoon fed newbie developer and try to move on.What software/tools should I really be looking at to develop quality code? Unit Testing, Continous Integration, Resharper, Mocking tools, DOI Containers, nHibernate.
I'm not really aware of blogs/books that will help me push on from being a proficient web developer into someone who can develop extensible, quality and testable code. There are big gaps in authors assumptions. You are either a newbie or a software architect. I want to push from being a junior developer with a long term aim of being a software architect. I realise it's all about patterns and practices but where are the training materials? I work on my own so don't have the opportunity of learning from others.
Debug-Start Debugging/Debug-StartWithoutDebugging OR Project ASP.Net Configuration launches Dreamweaver. It started lastnight, I had both Deamweaver and VWD 2008 express open at the same time - (I was looking at JQuery in the Microsoft and Dreamweaver enviroments simultaniously). After the first tie this happened, I closed down Dreamweaver (CS3) and it opened when I tried to run my VWD project. I reinstalled VWD 2008 express, IIS and disabled Dreamweaver (renamed the exe). Dreamweaver still came up.
MSDN got a page showing in which order ASP.Net global.asax methods are invoked. I can't seem to find it, anyone got a linkAre there a similar page, but for ASP.Net MVC (including in which order all controller methods are invoked like OnActionExecuting, OnAuthorization etc)?
ASP.Net app life cycle: http://msdn.microsoft.com/en-us/library/bb470252.aspx
How the does the gridview populate all records?.As the reader is capable of reading one row per read,I thought only the last row is available for GridView to display.
I am recording time taken by a page to be displayed to user, for which I am recording execution end time in page_PreRender. But if the page contains huge amount of data, then it is taking few more seconds after PreRender event. I also tried with Page_Unload, still the same.
script for Visual fox pro about shell execution in silent mode. I don't want to display the output of the running application in windows screen. I just trying to run the ".exe" file w/o viewing on screen.
I am new to IIS7 server I have a ASHX generic handler in ASP.NET, its process some mathematical data depending on the user data (which is hard to predict), mathematical model can use lot of memory and may put IIS server to hold all the other tasks I am trying to limit the memory that ASP .NET process can take and setup timeout limit for the max execution time for this .ASHX process i will be glad if any one can point me to the right direction to resolve this
Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)
When I am executing this query, it is taking 1-2 seconds to execute, but when I am using the same query in stored procedure, the below query is taking more than 5 minute:
If(Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12)) BEGIN -- CREATE TEMPORARY TABLE [Say: #temp1] #temp1 => Select a from tbl_abc where id in ( select id from tbl_xyz where mainid = 12) inserting the same value in the temp table drop #temp1 END
what could be the reason of this? and how can I resolve this? I am running the SP from asp.net
My task is to create an ASP.NET application with a piece of code which will automatically run every half an hour. This code must append a record to the file every half an hour. It should not depend on users requests(whether they happen or not).
1) I'm writing my code in Application.Start method of Global.asax file. Am I right?
2) Do I have anything to do with the hosting (IIS) settings (e.g. change permissions to write the file, etc)?
I have already tried just putting the code to write to file into a loop in Application.Start method and then just copied the project directory to the server. However, it didn't work.
I would like to check how long an ASP.NET page takes to execute (server stuff obviously, not interested in how long it takes to throw the results down the line and for the browser to render them at this stage).
Having done some searching, I came across http:[URL] which shows how to do just this. Trouble is, it doesn't work for me. I copied the code exactly, but the execution time is always zero.
I tried enabling tracing, and that showed an elapsed time between Page_Init and Page_PreRender, but the values returned by Environment.TickCount were exactly the same in both events, so the elapsed time was 9obviously) zero.
I need to find out the query execution time from the front end .Where should I insert the code for that.
I am using the bleow query:
OracleConnection con = new OracleConnection(ConnStr); con.Open(); OracleCommand cmd = new OracleCommand("Stored_Proc",con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(); .................... ................ OracleDataAdapter oda = new OracleDataAdapter (cmd);
when i am executing a simple query it is takeing 47 sec .... that is only for one table.. other then that remaing table perfromance is good... Help me out... and is there chance to get good perfomance through .net coding..
Can any one please provide link for flow of query exection in sql
For eg. FROM, [JOIN CONDITION, JOIN TABLE ...], WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY, TOP
Suppose when we write query, how that query will get execute behind. I would like to know about that. Can you please provide ariticles or link related to this
I'm executing one stored procedure from the '.net' code. Since there is a lot of data, it is taking too much time to execute. Is there any way to stop this execution from the c# code?
In other words, if we execute the query from database itself, there is a option to stop its execution but in the code is it possible?