Databases Reference
In-Depth Information
if (rs2.next()) {
Object photo = rs2.getObject(1);
displayPhoto(photo);
}
rs2.close();
}
}
rs.close();
With this application rewrite, less data must be processed off the network
when the user closes the application, which results in the application closing
more quickly.
The application in this case study allows users to refill their drug prescriptions
over the Web and check the status of their orders. It is an interactive Web-server
application.
Environment Details
The environment details are as follows:
•
Active Server Pages (ASP) is used to create the application.
•
The application makes ADO calls.
•
The database is Oracle running on Windows.
•
The database driver is an OLE/DB to ODBC bridge.
•
The client machines are running a variety of Windows operating systems,
such as Windows XP and Windows Vista.
•
The application is using connection pooling of Microsoft's Driver Manager
for connection management.
The Issue
The server is running out of memory, which causes poor overall performance.
What consumes memory on the server? The most likely culprits are defects in the
database driver, LOB data, scrollable cursors, statement pools, and connection
pools.
