Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Multi-threaded server - will it help in this case
Environment: AIX 4.3
Oracle 8.1.7
The application is a CAE tool which stores metadata for a hierarchy of 3D engineering design models. When a user opens a model at a given level in the design, the application retrieves data about that model and all of the models below it in the design try. This often involves as many as 100 or more models.
Unfortunately, the way the application is written, it
opens a new connection to the database for each model. Thus, in the process
of retrieving
metadata, it may open and close as many as 100 connections to the database.
Obviously, this causes some performance problems, especially for
remote users. The number of users when the system goes fully into
production
is going to be in the low 100's.
The vendor is not interested in changing the way the software works.
Will use of the mult-threaded server improve performance in this situation,
for
example, by eliminating the overhead of starting a dedicated server for each
connection?
Thanks,
Peter Schauss
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Schauss, Peter
INET: peter.schauss_at_ngc.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 11 2003 - 08:44:25 CST