My application works under IIS 5.1 and is connected with oracle 9.2
database. After a few days of working it starts to work slower aned
slower. I've checked connections with database if they are closed but
in Enterprise Menager Console - Instance - Sessions all connections
are closed. I've noticed that process aspnet_wp.exe uses more and more
memory, maybe this is the reason? Killing this process results in
getting my application work faster. What should I do to prevent my
application from getting slower. (I want to avoid restarting
aspnet_wp.exe process).What can I check except for connections and
aspnet_wp.exe process. Maybe it's another way to check closed
connections...? 3 1413
Sounds like there are some IDisposable objects in your app that you're not
disposing.
All IDisposable objects needs to be freed by you, and isn't collected
properly from the GC. SqlConnection, SqlDataReader and so on are all
IDisposable, meaning that you should always call obj.Close() when you're
done using them.
Another great way is to use C# using {} mechanism:
using (SqlConnection con = new SqlConnection(. ..))
{
using (SqlDataReader = ....)
{
}
}
This way, the Close() method is automatically called for the objects inside
the using clause.
'Hans Olav.
"mamin" <ma************ **@vp.pl> wrote in message
news:11******** **************@ u72g2000cwu.goo glegroups.com.. . My application works under IIS 5.1 and is connected with oracle 9.2 database. After a few days of working it starts to work slower aned slower. I've checked connections with database if they are closed but in Enterprise Menager Console - Instance - Sessions all connections are closed. I've noticed that process aspnet_wp.exe uses more and more memory, maybe this is the reason? Killing this process results in getting my application work faster. What should I do to prevent my application from getting slower. (I want to avoid restarting aspnet_wp.exe process).What can I check except for connections and aspnet_wp.exe process. Maybe it's another way to check closed connections...?
I've checked all places where Connection and DataReader is being used
but everywhere they're being closed.
I noticed, that applications starts to slow down, after running it from
another computer.I mean that from computer A i can run application and
it works fine, then I'm running application from computer B and after
that on both computers, application runs very slowly. And even after
restarting Oracle database, it still runs slowly. The only way to make
it faster is killing aspnet_wp.exe. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Gerald Khin |
last post by:
I encountered a performance problem with UPDATE statement and foreign
key constraints.
There are two tables involved: A parent table A and a child table B:
create table A(
ID CHAR(15) NOT NULL CONSTRAINT APK PRIMARY KEY,
val NUMERIC(10))
create table B(ID CHAR(15) NOT NULL CONSTRAINT BPK PRIMARY KEY,
|
by: Larry R Harrison Jr |
last post by:
I have a database I'm designing in Access 97. I have a custom field in a
query which looks in {Table of Documents} and shows them all. It then needs
a "latest revision number," stored in another table named {Table of
Revisions}. It naturally matches them up by linking the autoid in {Doc} with
the related field in {Rev}. It then looks for a field in {Rev} called
"revision number" and looks for the last one for the given Doc (linked by
the...
|
by: Carl Howarth |
last post by:
Sorry to repost, but I am fairly desparate to get this issue resolved!
Please see below, when it hangs if I leave it long enough I get a 'General
Network Error', or something similar. Could this be down to the web servers
being on the DMZ, or perhaps some configuration value in the web.config
file?
Any help would really be appreciated as I am due to put the system live
ASAP.
|
by: Andy Oakey |
last post by:
We have written an ASP.NET application in VB connecting to a SQL
Server database. It is run across an internal network at a client
site, with around 30 users on the site. They open the application each
morning an over the course of the day it gets slower and slower. If
they close IE, open a new browser window and re-enter the application
it's fast again, but slows down over time.
Anybody know what could cause this? All our data...
|
by: Tony Fonager |
last post by:
I am currently developing a statistics system in ASP.NET, and need to share
information about the customers websites, in this application.
(I have simplified my code, to make my project easier to explain.)
The simple version of the system is like this : A customer inserts HTML code
on his webpage, which contacts my statistics server each time the customers
website recieves a hit - like a classic "register website traffic" system.
...
| |
by: Jose Walker |
last post by:
Hi there,
I've an ASP.NET 2 web application that I want to publish, but it happened
that the application slows down in performance compared with the version
managed by VS.NET 2005.
When the application is being developed and tested inside VS.NET 2005 is
really fast; once deployed by the publishing option slows down and time to
time crashes.
|
by: jphelan |
last post by:
Ever since I successfully applied some techniques for increasing the
speed of my 17 meg. Application; it has only made me hunger for more.
First, let me list what I have done so far:
1. Split the application and database into front and back-ends,
2. Increased the load-time of my application by "pre-loading my
heaviest forms when the database is initially opened,
3. When forms do open, under, "Filter Lookup" I use, "Never",
4. I set...
|
by: jacc14 |
last post by:
Good morning all.
I have been working on a database for the past couple of weeks and it is pretty nippy. I have an ODBC link in there from another software program.
Since splitting it and putting the backend in a backend folder (on the same network) may I add, it has really slowed down. When you first open the form it is quite quick but after that it slows down. Its as if there is something running in the background. Not sure if my...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |