| Coreen,
You can still use Rdbexpert and DECtrace to help design the physical
database. There is no connection to the application tool required
for the database tuning. Does PROGRESS produce compiled/interactive SQL that
you can read. If so it will help to have this transaction information
for the initial database design (one of the inputs to Rdbexpert).
I am not familiar with PROGRESS, but if you can insert calls to
DECtrace within the application, then you can also use DECtrace
to collect specific application metrics.
Ken M
|
| Coreen,
First, I assume it is a redevelopment and not a conversion. Conversion
implies that part of the existing code is automatically converted.
If it is a total rewrite, then it is a redevelopment and should
include a review of its functionality if possible. You don't want
to move the same mis-functions across.
I would check with the PROGRESS people and some reference sites.
PROGRESS is implemented in a Client/Server model so it is important
to determine who is doing the reads and writes; The user process?
a detached job? and spawned (shades of Ingres) job? You could run
into some interesting system configuration challenges.
We have a copy of the software at our office so I'll see if there
is anything in it which will help. One piece of advice is to determine
how much on the hook DEC is for performance and ensure the appropriate
3rd parties (e.g. PROGRESS) are also on the hook if it doesn't run.
Paul
|