Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^2: DBD::Oracle faster with bound sql than stored procedures?

by Jonathan (Curate)
on Nov 24, 2006 at 17:00 UTC ( #585911=note: print w/ replies, xml ) Need Help??


in reply to Re: DBD::Oracle faster with bound sql than stored procedures?
in thread DBD::Oracle faster with bound sql than stored procedures?

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.


Comment on Re^2: DBD::Oracle faster with bound sql than stored procedures?
Re^3: DBD::Oracle faster with bound sql than stored procedures?
by Tanktalus (Canon) on Nov 24, 2006 at 22:00 UTC

    Why on Earth would I swap my RDBMS? Well, because IBM or MS or whomever offered a much better deal. I've heard that these companies (including Oracle, of course) compete quite a bit ;-)

    What you do now can seriously impact how easy it is to switch, should your non-technical management decree it. If you take advantage of Oracle-specific functions, you can drastically speed up your queries, speed up your development, and hurt your ability to switch should the need arise. Kind of a trade-off.

    Personally, though, while I understand the concept and need for the ability to switch, I'd still go with whatever gave me the maximum benefit under the current infrastructure, without impacting maintainability in a negative way, and then tell management what the costs were to switch our application for when other sales guys approach them to get us to switch. It still may come out as a benefit to switch because the switch itself is a one-time charge, while the licensing and support is an ongoing charge.

      The cost of database licenses is a relatively minor component in the total cost of the whole project. If you have a pool of Oracle developers who understand your application and business then you're pretty well locked in.

      Again, this is from a large project/large corporation perspective.

      That seems a little silly to me. Hypothetically speaking, of course.. If I bought Oracle, then MS offered me a better deal, I'd have sunk costs from buying Oracle. It wouldn't make any sense to switch to Oracle. I think the nightmare of transporting the data from one database to another more than offsets the nightmare of tying yourself to a vendor's stored procedure methods (which, by the way, exist in all major RDBMS software).
Re^3: DBD::Oracle faster with bound sql than stored procedures?
by exussum0 (Vicar) on Nov 25, 2006 at 04:30 UTC
    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.
    'cause it's life. Sometimes changes happen due to cost, politics and various other reasons. It just happens.

    As for what is swapped out, a well designed system can have any layer of responsibility removed and replaced due to light coupling. i.e. Dont' do database calls from your template system.

Re^3: DBD::Oracle faster with bound sql than stored procedures?
by andreas1234567 (Vicar) on Nov 25, 2006 at 13:00 UTC
    Why on Earth would you want to swap your RDBMS?
    I never wrote that. I'm exploring a new platform of curiosity, trying so see what it has to offer. So far it seems very promising.
    If you don't know who 'Ask Tom' then perhaps you should find cout.
    I bought one of his books and I will continue to read his columns.
    As for maintaince nightmares. Yup, I've seen those, Embedded dynamic SQL in Java code was the worst.
    I second that.
    As for the Oracle client C library, yes its blisteringly fast.
    Do you mean replacing DBD::Oracle with some kind of compiled C routines?

    Andreas
    --
      Do you mean replacing DBD::Oracle with some kind of compiled C routines?

      No, DBD::Oracle uses the Oracle client software. You don't need to use any 'C' code.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://585911]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (9)
As of 2014-08-21 22:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (144 votes), past polls