Re: pros and cons of using stored procedures
Date: Sat, 08 Sep 2001 13:44:32 GMT
Message-ID: <3b9a1d0d.5735417_at_news.interbusiness.it>
On 07 Sep 2001 15:47:56 -0700, Rusty Wright
<rusty_at_socrates.Berkeley.EDU> wrote:
>Can anyone recommend a book, web page, etc. that explains the pros and
personally, as we're also working on a project based on the three db
(interbase) - php - web, i've also come into the same question: SPs or
not? I took care of the db side of the project and i decided to use
them as much as possible.... you can find an article about SPs on
interbase web site, that applies to SPs in general, too.
i actually haven't found drawbacks in SPs, so if your group is
pointing out something against SPs, well i'll be pleased if you could
let me know that.... we might even discuss about it.
Roberto Padovani
>cons of using stored procedures, as opposed to putting the code in
>your front-end code? The background info is that a group of us are
>designing a database and we'll be using Oracle, and for the front-end
>we'll be using a web interface probably with the PHP scripting
>language as the glue.
>
>One of the people on the team is a proponent of using stored
>procedures and another is against it. Obviously, none of us are
>database experts and I'd like to be able to read up on stored
>procedures so that we can argue the issue intelligently.
>
>Thanks
whenever i look for that kind of info i start from
http://www.palslib.com
i've found links for almost everything i ever needed for my db related
questions. That's NOT my site, i'm not advertising, and i don't know
Pal directly... i just found there a lot of links to interesting
resources and, most of all, Pal has been very kind answering to my
email.
ICQ#125729644
Received on Sat Sep 08 2001 - 15:44:32 CEST