Execute sp_who2and look for rows that are blocked on another connection (the BlkBy column will have the spid of the blocking connection in it).
kill xx(xx = spid).
editoption: { value: "FE:FedEx; IN:InTime; TN:TNT" }Solution: For example to load a list of countries dynamically, define the variable before the definition of the jqGrid:
//get all countries
var countries = $.ajax({url: $('#ajaxAllCountriesUrl').val(), async: false, success: function(data, result) {if (!result) alert('Failure to retrieve the Countries.');}}).responseText;
$(yourgrid).jqGrid({Important: The ajax call to retrieve the countries must be set to "async: false" otherwise you have a very good chance that the grid will be defined before the data is actually returned. Using the same logic you can reload the list based on some other event and trigger the reload of the grid if need be to reload the new list.
...
colModel: [
{ name: 'Id', index: 'Id', width: 20, sortable: true, align: "center", editable: false, editoptions: { readonly: true, size: 0 }, search: true },
{ name: 'Country', index: 'Country', width: 80, sortable: true, editable: true, edittype: "select", editrules: { required: true }, editoptions: { size: 71} }
],
...
loadComplete: function() {
$(item).setColProp('Country', { editoptions: { value: countries} });
},
...
Every file that is included and loaded into your web-page is represented by one row in the table. Notice how the files are loaded not just one after the other, but also when they start loading and end loading by looking at the file's bar. The bar shows you when the file started and stopped loading relative to all the other files. In this example the notice how the second file (after Get 1) is only starts loading after its predecessor (GET 1) has ended, but how the four files loaded after the first one's bars overlap. The first file is a JavaScript file, which are loaded one at time, never in parallel. The second to fifth files are also JavaScript files, but they are loaded from the cache and can be loaded in parallel. The last five files in this example are images.Note that the order of the files in the list denotes the order in which the files where loaded from the server. Also take note that js files are loaded in sequence, one-after-the-other.
Break it down by type
Cached or not cached
Files loaded in sequence (not parallel) follow each other, you can see this by the bars not overlapping. This is not true for cached js files however, as can be seen for the js files loaded with a "304 Not Modified" HTTP status code. See how the images are loaded in parallel?! These are all indicators of bottlenecks and design issues that can be a great tool in performance tuning your app.
Lets see what the effect is of setting for caching a file. Have a look at the GetjQueryScripts file that is loaded (by the way this is a call to an MVC action method called GetJqueryScripts that loads one js file for all jQuery scripts by combining them on the server). Note in the example to the left that "GET GetjQueryScript" has a status of "200 OK". This means it has been loaded from the server (not a cached version). I also took 2.36s (seconds) to load from the server. This is the first time this JavaScript file is loaded from the server although caching has been set for this file.
Now lets see what happens on the next page request. Notice how the HTTP status has changed from "200 OK" to "304 Not Modified". Since the file has caching enabled, it told the client (your browser) to cache the file for a predetermined amount of time for subsequent requests. There are three tabs now, as apposed to the previous example where there was only a Headers and Response tab, now there is also a Cache tab, denoting that this file was cached.
Some of the information in the cache shows the time it was last modified and how long this file will be cached for, which is the Expires property that tells you that it expires in about 8 hours. It also shows how often this file was requested, and in this case 106 times from the disk (cache location for the browser on your machine).
XMLHttpRequest monitoringFirebug adds a global variable named "console" to all web pages loaded in Firefox. This object contains many methods that allow you to write to the Firebug console to expose information that is flowing through your scripts.
Writes a message to the console. You may pass as many arguments as you'd like, and they will be joined together in a space-delimited line.
The first argument to log may be a string containing printf-like string substitution patterns. For example:
console.log("The %s jumped over %d tall buildings", animal, count); The example above can be re-written without string substitution to achieve the same result:
console.log("The", animal, "jumped over", count, "tall buildings"); These two techniques can be combined. If you use string substitution but provide more arguments than there are substitution patterns, the remaining arguments will be appended in a space-delimited line, like so:
console.log("I am %s and I have:", myName, thing1, thing2, thing3); If objects are logged, they will be written not as static text, but as interactive hyperlinks that can be clicked to inspect the object in Firebug's HTML, CSS, Script, or DOM tabs. You may also use the %o pattern to substitute a hyperlink in a string.
Here is the complete set of patterns that you may use for string substitution:
| String Substitution Patterns | |
| %s | String |
| %d, %i | Integer (numeric formatting is not yet supported) |
| %f | Floating point number (numeric formatting is not yet supported) |
| %o | Object hyperlink |
Writes a message to the console, including a hyperlink to the line where it was called.
Writes a message to the console with the visual "info" icon and color coding and a hyperlink to the line where it was called.
Writes a message to the console with the visual "warning" icon and color coding and a hyperlink to the line where it was called.
Writes a message to the console with the visual "error" icon and color coding and a hyperlink to the line where it was called.
Tests that an expression is true. If not, it will write a message to the console and throw an exception.
Prints an interactive listing of all properties of the object. This looks identical to the view that you would see in the DOM tab.
Prints the XML source tree of an HTML or XML element. This looks identical to the view that you would see in the HTML tab. You can click on any node to inspect it in the HTML tab.
Prints an interactive stack trace of JavaScript execution at the point where it is called.
The stack trace details the functions on the stack, as well as the values that were passed as arguments to each function. You can click each function to take you to its source in the Script tab, and click each argument value to inspect it in the DOM or HTML tabs.
Writes a message to the console and opens a nested block to indent all future messages sent to the console. Call console.groupEnd() to close the block.
Closes the most recently opened block created by a call to console.group.
Creates a new timer under the given name. Call console.timeEnd(name) with the same name to stop the timer and print the time elapsed..
Stops a timer created by a call to console.time(name) and writes the time elapsed.
Turns on the JavaScript profiler. The optional argument title would contain the text to be printed in the header of the profile report.
Turns off the JavaScript profiler and prints its report.
Writes the number of times that the line of code where count was called was executed. The optional argument title will print a message in addition to the number of the count.
Firebug is a free Firefox extension. Ready to install?
[OutputCache(Duration = 7200, VaryByParam = "none")]
public FileResult GetjQueryScripts()
{
string combinedResults = combineLikeDirectoryFiles("~/Scripts/jquery/Base/", FileType.js);
combinedResults += combineLikeDirectoryFiles("~/Scripts/jquery/Plugins/", FileType.js);
combinedResults += combineLikeDirectoryFiles("~/Scripts/jquery/Plugins/jquery.grid/", FileType.js);
combinedResults += combineLikeDirectoryFiles("~/Scripts/jquery/Plugins/jquery.datepick/", FileType.js);
return streamText(combinedResults, js);
}
[OutputCache(Duration = 57600, VaryByParam = "none")]
public string GetAllStates()
{
return GetAllForGenericData(Repository.FindAll());
}
[CustomOutputCacheAttribute(TypeOfFileToCache = FileType.js, VaryByParam = "none")]
public FileResult GetjQueryScripts()
{
string combinedResults = combineLikeDirectoryFiles("~/Scripts/jquery/Base/", FileType.js);
combinedResults += combineLikeDirectoryFiles("~/Scripts/jquery/Plugins/", FileType.js);
combinedResults += combineLikeDirectoryFiles("~/Scripts/jquery/Plugins/jquery.grid/", FileType.js);
combinedResults += combineLikeDirectoryFiles("~/Scripts/jquery/Plugins/jquery.datepick/", FileType.js);
return streamText(combinedResults, js);
}
public class CustomOutputCacheAttribute : OutputCacheAttribute
{
private FileType _typeOfFileToCache;
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
SetupDuration();
base.OnActionExecuting(filterContext);
}
public FileType TypeOfFileToCache
{
get { return _typeOfFileToCache; }
set { _typeOfFileToCache = value; }
}
public string VaryByParam
{
get { return base.VaryByParam; }
set { base.VaryByParam = value; }
}
public void SetupDuration()
{
int durateMe;
switch (TypeOfFileToCache)
{
case FileType.js:
{
base.Duration = int.TryParse(ConfigurationSettings.AppSettings[ "outputCacheDurationScriptLoad" ],
out durateMe)
? durateMe
: 0;
}
break;
case FileType.css:
{
base.Duration = int.TryParse(ConfigurationSettings.AppSettings[ "outputCacheDurationCssLoad" ],
out durateMe)
? durateMe
: 0;
}
break;
default:
base.Duration = 0;
break;
}
}
}
public enum FileType
{
js = 1,
css = 2
}