PowerHouse and RDBMS issues

[Rich `Lego-Man' Jesse - 7633]

Louis Brouillette replied:

LO> We migrated from Interbase 3.3 to Oracle 7.3.  Problems were:
LO> 
LO> 1) There is no "computed fields" in Oracle 7 ( or 8 either).  So, we had to
LO> convert all computed fields to functions and create a view on each table
LO> which had a computed field and then, in all PH programs, we had to add a
LO> link to the view when the program was using a "computed field".
LO> 
LO> 2) The logic of some triggers had to be modified because of "mutating
LO> table" problem in Oracle.  Triggers were easier in Interbase.

Possibly, but I think that they may have been easier in IB3.3 because the
triggers are not as flexible as in Oracle.  And as you alluded to, Oracle only
requires hardware to perform.  Interbase has many limitations as to total
thru-put, especially in version 3.3, regardless of hardware.

LO> 3) We had to add "commit at update" in some QTPs.  As far as I can
LO> remember, it is because Interbase has "optimistic" locking and Oracle don't.

Also don't forget the rollback segment size in Oracle.  Updating several
thousand rows may fill the rollback segment -- unless you've got a good DBA
that talks to your programmers.

Finally, IB3.3 leaves you with your pants around your ankles, if you'll pardon
the expression.  Two #%$@@#^$ days before our conversion to Oracle, our IB
database took a major dump.  Major enough that we lost nearly a days' worth of
data and uptime.  With the way we've setup Oracle, it would take a cataclysmic
event for us to lose data.  Major enough that we probably wouldn't be around to
know our data was gone...

O.K., just one more thing:  You pay for what you get.

Enjoy!

Rich Jesse                              Programmer/Analyst (/DBA/SysAdmin/etc.)
rjesse@qtiworld.com                     Quad/Tech International, Sussex, WI USA
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.