Re: [PHP] Re: Somewhat OT - Stored Procedures

2011-03-07 Thread Nathan Nobbe
On Sat, Mar 5, 2011 at 5:31 AM, Florin Jurcovici florin.jurcov...@gmail.com wrote: Hi. I would always recommend stored procedures, as long as there are a very few rules obeyed: - keep them simple - they should mostly implement just CRUD operations plus application-specific searches, and

[PHP] Re: Somewhat OT - Stored Procedures

2011-03-05 Thread Florin Jurcovici
Hi. I would always recommend stored procedures, as long as there are a very few rules obeyed: - keep them simple - they should mostly implement just CRUD operations plus application-specific searches, and should not encapsulate any other logic - use just portable SQL (well, as long as this is

Re: [PHP] Re: Somewhat OT - Stored Procedures

2011-03-05 Thread NetEmp
Hi Team I very much agree with the points shared by Florin (esp. the two rules). But unfortunately, these rules are not standards and that is where the real problem lies. The injudicious use of SPs leads to un-manageable code which is rarely portable (real life situations J which are too

Re: [PHP] Re: Somewhat OT - Stored Procedures

2011-03-05 Thread NetEmp
Hi Team I very much agree with the points shared by Florin (esp. the two rules). But unfortunately, these rules are not standards and that is where the real problem lies. The injudicious use of SPs leads to un-manageable code which is rarely portable (real life situations J which are too

[PHP] Re: Somewhat OT - Stored Procedures

2011-03-04 Thread Nathan Rixham
Hi Nathan, Nathan Nobbe wrote: Also, bear in mind that personally I tend to favor OO paradigms for application development so would prefer feedback that incorporates that tendency. Initial thoughts are Bad: . Not well suited for ORM, particularly procedures which return multiple result sets