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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).