Hi, We were thinking to implement the solution as "Stored Procedures" > instead of a PHP solution that runs SQL queries, but an article in > Coding Horro recommendeds to avoid SP for good reasons:
The article shows only one thing. that common practice should be to 'do everything where it belongs' If you implement this practice within your application, it becomes more maintainable, more performant and easier to develop. Also, to determine the styles used to write your code, is almost entirely dependent on a few things: * Programmer's preference * The problem you are solving * The standards that are commonly used in the environment you are in Is there any benefit to use OOP in these situations? Benefits of OOP are that it becomes easier to implement a more standardized code structure, better match with reality, clearer code, more structure, re-usability, and a modular design. These can all be done in procedural code as well, the difference being you need a different mind- and skillset. HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table 2013/2/17 Marco Behnke <ma...@behnke.biz> > Am 17.02.13 17:00, schrieb AmirBehzad Eslami: > > Dear list, > > > > We have a bunch of SQL-queries, they should be executed in > > a sequential order, with a defensive programming style in mind. > I don't understand what you want? > Queries are executed sequentially or do you plan to create a > multi-process PHP application? > > > > We were thinking to implement the solution as "Stored Procedures" > > instead of a PHP solution that runs SQL queries, but an article in > > Coding Horro recommendeds to avoid SP for good reasons: > > > > > http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html > > > > Now we're going to carry on in PHP, and my experience says that > > we should write the solution in a procedural-style, instead of OOP. > > > > Is there any benefit to use OOP in these situations? > > > > Please share your thoughts. > > > > Thanks, > > -behzad > > > > > -- > Marco Behnke > Dipl. Informatiker (FH), SAE Audio Engineer Diploma > Zend Certified Engineer PHP 5.3 > > Tel.: 0174 / 9722336 > e-Mail: ma...@behnke.biz > > Softwaretechnik Behnke > Heinrich-Heine-Str. 7D > 21218 Seevetal > > http://www.behnke.biz > > >
