Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h3>Fast and short answer:</h3> <p>Configure the application pool used by the web application to enable 32-bit applications:</p> <p><img src="https://i.stack.imgur.com/f8wYm.png" alt="Set Enable 32-bit applications to True"></p> <h3>Detailed walkthrough:</h3> <p>I used some <a href="https://stackoverflow.com/questions/3927/what-are-some-good-net-profilers/379641" title="What Are Some Good .NET Profilers?">performance profiling tools</a> (some are <a href="https://stackoverflow.com/q/308816/379641" title="Any Good Free .NET Profiler?">free</a>) to compare the performances and to find out the bottlenecks. The free <a href="http://www.eqatec.com/tools/profiler" rel="nofollow noreferrer">EQATEC Profiler</a> is good enough to allow me compare two reports generated from running Cassini and IIS and identify the method causing the problem. However, the method contains too many lines and I was unable to pinpoint the exact line causing the problem.</p> <p>Then <a href="http://www.red-gate.com/products/ants_performance_profiler/" rel="nofollow noreferrer">Redgate ANTS</a> comes in handy. By profiling the method with line-level detail, I found that it was RegEx running very slowly.</p> <p>Further searching leads me to the answer here: <a href="https://stackoverflow.com/a/11375223/379641">RegEx.Match is much slower in IIS compared to Development Server (Cassini)</a>. I am using Windows 7 64bit with IIS 7. Setting the "Enable 32-bit applications" to True solves the problem.</p> <hr> <p>Also, a slightly related reading on running IIS as 32bit or 64bit:</p> <blockquote> <p>64-bit servers are much more effective when used for databases like SQL Server, or other data management servers (let's say, an enterprise email server like Exchange), than for <strong><em>processing servers</em></strong>, such as <strong>IIS</strong> or the worker processes it manages.</p> <p>It will require 64-bit pointers for every lookup, which will make everything a little slower.</p> </blockquote> <p>Source: <a href="https://stackoverflow.com/a/2061731/379641">What are the pros and cons of running IIS as 32bit vs 64bit on a 64bit OS?</a></p>
    singulars
    1. This table or related slice is empty.
    1. POWhy is IIS slower than ASP.NET Development Server?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USGan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhy is IIS slower than ASP.NET Development Server?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COYou only listed a few corner cases, without mentioning that Cassini is simply a toy, without strong security/long pipeline/kernal-user mode separation/application pool (which can hurt performance, but are essential for a production level web server). Via scalability you can still serve many users with acceptable performance on IIS, while Cassini can never achieve the same level of robustness.
      singulars
      1. PO
      1. USLex Li
    2. CO@LexLi, I intend to make this page a repository of reasons that could make IIS runs slower than Cassini. Do you mind explaining, as separate answers, how the factors you mentioned could bring huge impact to IIS, and also ways to rectify them?
      singulars
      1. PO
      1. USGan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload