forumuser7
New Member
Hi,
We have a progress 9.1d application running on a Unix server. This server is mainly used for development and tests.
The application was running just fine fine for the past year or so..
We recently updated the programs and the database (we restored a backup from another server - production machine) and we noticed that it takes much longer now to browse a particular table.
The initial time for loading is much longer than before. (it takes 1 minute or so...) Any consecutive attempt to browse the same table takes only 1-2 seconds...
Even if we quit the application and start it again the time to load the table is 1-2 seconds...
We noticed that if we restart the database brokers then again the initial table browse would take longer than normal...
I know that:
1. the production server is a better (faster) machine than the development machine
2. The database has grown for the past year or so...is a little bit bigger now...
Is there a way to find out what is the problem?
Where is the bottleneck ?
Any ideas what could e the problem?
Thank you for the help in advance!
We have a progress 9.1d application running on a Unix server. This server is mainly used for development and tests.
The application was running just fine fine for the past year or so..
We recently updated the programs and the database (we restored a backup from another server - production machine) and we noticed that it takes much longer now to browse a particular table.
The initial time for loading is much longer than before. (it takes 1 minute or so...) Any consecutive attempt to browse the same table takes only 1-2 seconds...
Even if we quit the application and start it again the time to load the table is 1-2 seconds...
We noticed that if we restart the database brokers then again the initial table browse would take longer than normal...
I know that:
1. the production server is a better (faster) machine than the development machine
2. The database has grown for the past year or so...is a little bit bigger now...
Is there a way to find out what is the problem?
Where is the bottleneck ?
Any ideas what could e the problem?
Thank you for the help in advance!