note
Jonathan
Why on Earth would you want to swap your RDBMS?
<p>
If you're paying for Oracle it's because you need Oracle. And having paid for it you'd better use it.
<p>
If you don't know who 'Ask Tom' then perhaps you should find out. His advice is invaluable in building large scalable Oracle databases.
<p>
Personally, I'd use stored procedures for virtually all database access. I'd also put all the business logic I could into the the procs. Coupling your data and business logic protects your application.
<p>
It's the front ends that should be easily swapped out and changed not the database.
<p>
As for maintaince nightmares. Yup, I've seen those, Embedded dynamic SQL in Java code was the worst.<p>
As for the Oracle client C library, yes its blisteringly fast.
<p>
585869
585883