Solved

Increase IIS Performance

Posted on 2004-04-29
4
531 Views
Last Modified: 2012-06-27
I have a .Net webform application hosted on Windows 2003 Server running IIS.  Its a new Dell PowerEdge server.

My Problem: anytime someone accesses the web application, it takes forever (two to three minutes) to return a result of a database query the application is performing.  Each subsequent use of the application within the same browser session has instantaneous results.

There's no performance tuning available to me on the PervasiveSQL Workgroup Database Engine that this application is calling.  Further, I have the same function in Windows Application and its always instantaneous.  Therfore, I'm fairly certain it is a performance issue with IIS.

Any tips?
0
Comment
Question by:carlajasminelewis
  • 2
4 Comments
 
LVL 37

Assisted Solution

by:meverest
meverest earned 250 total points
ID: 10954558
how long does the same query take when you use query analyser or some other database query mechanism?

is it possible that it is just a long running query that is cached after the first time?
0
 
LVL 1

Author Comment

by:carlajasminelewis
ID: 10954986
The same query is *BAM* instantaneous in the SQL Data Manager  (Pervasive's Query Builder).  Like I mentioned, I put the same function into a stand-alone windows application and its instantaneous there too.  Its only when running on a web form in IIS that it seems slow.
0
 
LVL 1

Accepted Solution

by:
Ken-doh earned 250 total points
ID: 11106453
are you using a file server with IIS or are the files hosted locally?
0
 
LVL 1

Author Comment

by:carlajasminelewis
ID: 11117165
I restarted IIS and works fine.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What is an ISAPI filter?   •      It's an assembly (.dll file) that can add or change the way IIS works.   •      They can be enabled globally for your web server or on a site-by-site basis.   When the IIS server receives a request, enabling the ISAPI fi…
Lync server 2013 or Skype for business Backup Service Error ID 4049 – After File Share Migration
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question