Oracle & Pro4
Posted 02 September 1999 - 03:36 PM
we are using Oracle 8.0.5, ProIV 4.6 and windows NT 4 at present. We have found that there are numerous problems
with this combination, but the biggest one we have found is
that the transparent SQL generated by PRO IV is at least twice as slow as full function SQL and also the CPU usage
is almost 100% with transparent SQL.
We have migrated 800+ functions from Unix and CISAM using
transparency mode and we are now probably faced with a
re write of all of them to add full function SQL to enable
the system to perform properly.
We converted our CISAM files by writing our own extracts
and then using SQL LOADER to put them into ORACLE. Do NOT
use the PRO IV FACT utility as it is very slow - what we
wrote ourselves took 6 hours to unload and reload 100 tables
(about 1gb), the FACT utility took 5 (yes five) days !
You may like to look at the message I posted today as we are still having problems with the Oracle/PRO IV interface
which PRo IV can't solve.
I can't help you with the cost of the interface as it is
supplied to us by one of our customers.
Posted 02 September 1999 - 03:47 PM
We have just done performance testing with 4.6 and oracle 8.0.5 and our results are the same as Bob's. Embedding SQL into PRO-IV seemed the only way to speed things up as PRO-IV's default was very slow.
Also our big batch processes need to be totally re-written to take advanted of Oracle performance issues, as PRO-IV just output too much SQL.
Never heard of FACT but we wrote our own extract functions and used SQLLOADER too. We had 40GB of CISAM & PRO-ISAM to convert (With all our history it's around 400 GB!!), so it would have taken weeks by the sound of it with FACT.
Also Oracle needs alot more 'babysitting' and monitoring once in a live system, compared to CISAM which just looks after it's self.
Posted 02 September 1999 - 03:59 PM
We're doing Oracle 7.3.4 on PRO-IV 4.0 on VMS and there's LOTS of bugs in the PRO-IV kernel.
One good story - we used a modified version of Glovia's DBC tools to do stage 1 of conversion and it is reasonably fast...
Posted 02 September 1999 - 08:09 PM
2. data integrity
3. speed *can* be improved in some cases
4. open database - you can use tools other than PRO-IV
5. PL/SQL is good for things like interfaces etc.
6. Indexes - you don't need to maintain cross-reference files any more because Oracle does it for you
There are many benefits, but you *do* have to be careful to make sure you make the most of them!
GREYCELL SYSTEMS LIMITED
Posted 03 September 1999 - 01:00 AM
Posted 03 September 1999 - 03:22 AM
Yes it runs slower than native ProIV but we are looking into using stored procedures as we have been told these are heaps faster.
The only way to load the tables is to write a ProIV unload function and use SQLLOADER to load the Oracle tables. You will need assistance of DBAs to get Oracle to perform properly.
Lots of advantages because now simple reporting requests can be done using SQL. We dont use Oracle for rollbacks etc as we dont have proper commit points across transactional boundaries and we have had to add commits to some functions to get them to work properly.
Posted 03 September 1999 - 09:50 AM
Posted 19 December 1999 - 10:44 PM
Obviously quite a lot of effort has been expended ensuring adequate performance, including spending several weeks at a benchmark centre.
This experience suggested it was possible to achieve performance parity with ISAM using approximately twice the CPU horsepower plus twice the RAM.
We used no explicit SQL whatsoever.
Posted 19 December 1999 - 10:55 PM
I actually implemented an extension to the Pro-IV kernel to speed up dumping the data in the correct format for SQL*Loader.
Running multiple dumps and loads in parallel on a beavy-duty HP machine I've seen 10Gb of data dumped and loaded in a couple of hours.
Posted 19 December 1999 - 11:05 PM
Some of the most basic advantages are that your customer's files don't get corrupted and can grow beyond 192Mb/384Mb/2Gb and that you can run 24x7.
Posted 19 December 1999 - 11:12 PM
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users