Question:
---------
Can you give me some tips on improving system performance on 
my databases as we create many records per day, do quite a 
bit of number crunching, and find the performance quite slow 
for some functions.

Answer:
------

Use a separate server.pf files for each database in the 
connection file (mxp.con, mapics.con, daemon.con,etc).  See 
the samples of server.pf files at the bottom of this tip.

For the application database, 

1) increase the -B parameter value.  This might improve the 
speed of your system.  Verify the number of hits for buffers 
using Progress’ promon utility.  If you have < 85% hit rate 
then increase the buffer size while watching the hit rate.

2) increase the number of -bibufs (before image buffers).  
If you can obtain a waiting time of close to 0, again using 
Progress’ promon utility, then every time a new record is 
created, the system will have minimum wait time to write to 
a buffer.

For all your other databases, you will have to find the 
optimum value from trial and error, but certainly, you do 
not need to have (in your server parameter file) as many 
resources allocated to the non-application databases.

Application database:
 $pg servera.pf
-B 20000                    #BUFFERS
-c 200                      #INDEX CURSORS
-L 500000                   #LOCK TABLE
-n 25                       #NUMBER OF USERS
-Mn 1                       #NUMBER OF SERVERS PER DATABASE
#-N tcp                     #NETWORK TYPE
#-S <server-name>           #SERVER NAME
#-H <host-name>             #HOSTNAME
-dt PROGRESS                #DATABASE TYPE
-Mxs 250
-bibufs 150

Schema database
 $pg servers.pf
-B 2000                     #BUFFERS
-c 200                      #INDEX CURSORS
-L 100000                   #LOCK TABLE
-n 25                       #NUMBER OF USERS
-Mn 1                       #NUMBER OF SERVERS PER DATABASE
#-N tcp                     #NETWORK TYPE
#-S <server-name>           #SERVER NAME
#-H <host-name>             #HOSTNAME
-dt PROGRESS                #DATABASE TYPE
-Mxs 250
-bibufs 20

Menu Database
$pg serverm.pf
-B 2000                     #BUFFERS
-c 200                      #INDEX CURSORS
-L 100000                   #LOCK TABLE
-n 25                       #NUMBER OF USERS
-Mn 1                       #NUMBER OF SERVERS PER DATABASE
#-N tcp                     #NETWORK TYPE
#-S <server-name>           #SERVER NAME
#-H <host-name>             #HOSTNAME
-dt PROGRESS                #DATABASE TYPE
-Mxs 250
-bibufs 20