is it a good solution?
1 posts in topic
Flat View  Flat View

Posted By:   zhebin_cong
Posted On:   Saturday, December 7, 2002 03:46 AM

all the database provide the function and stored procedure to allow the programmer to encaptulate part of the application logic,such as the java stored procedure from the oracle,it said that it will provide more performance promotion.
who can tell me if such a solution is a good mechanism from the aspect of performance and design pattern?

Re: is it a good solution?

Posted By:   Brian_Kapellusch  
Posted On:   Saturday, December 7, 2002 10:04 AM

I'm not a big fan of stored procedures to encapsulate business logic. While you will certainly get better performance from putting the work in the database, your code is much less portable. For example, if you ever want to switch from Oracle to something else, it will be difficult.

With that said, Oracle's the kind of product that businesses don't migrate AWAY from. So, if you're planning on sticking with Oracle until the end of time (relatively speaking), it's not a big deal.
About | Sitemap | Contact