|Think about Loose Coupling|
Re^2: DBD::Oracle faster with bound sql than stored procedures?by Jonathan (Curate)
|on Nov 24, 2006 at 17:00 UTC||Need Help??|
Why on Earth would you want to swap your RDBMS?
If you're paying for Oracle it's because you need Oracle. And having paid for it you'd better use it.
If you don't know who 'Ask Tom' then perhaps you should find out. His advice is invaluable in building large scalable Oracle databases.
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.
It's the front ends that should be easily swapped out and changed not the database.
As for maintaince nightmares. Yup, I've seen those, Embedded dynamic SQL in Java code was the worst.
As for the Oracle client C library, yes its blisteringly fast.