tag:blogger.com,1999:blog-375697951860081841.post2973119532165177661..comments2008-05-18T04:51:38.777+01:00Jonathanhttp://www.blogger.com/profile/17336586681878234499noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-375697951860081841.post-55307113068740338342008-05-18T04:51:00.000+01:002008-05-18T04:51:00.000+01:00Sheeri,<BR/><BR/>I have been trying to explain some of the ideas I had in my past posts. This time, I wanted to try a different approach, which is to just give practical examples and let people choose for themselves.<BR/><BR/>Stored procedure, Views or application code... you choose whatever is more comfortable for you.<BR/>Although, I do agree with what you mentioned and that it will probably be more comfortable to do that way.<BR/><BR/>I wrote this article in the hope that people who didn't know about these options, will be introduced to them.<BR/><BR/><BR/>P.S. Sheeri, thank you for following and commenting on my blog since the very beginning. I really appreciate and respect your feedback<BR/>P.P.S. also Roland, thank you for the same reason :)Jonathanhttp://www.blogger.com/profile/17336586681878234499noreply@blogger.comtag:blogger.com,1999:blog-375697951860081841.post-22678917620269731112008-05-17T19:57:00.000+01:002008-05-17T19:57:00.000+01:00Jonathan,<BR/><BR/>If you end up finding yourself with tons of views, it may be easier to generate stored procedures to do the work. That way you do a simple<BR/><BR/>call(get_cleaned_emails)<BR/><BR/>as your query. In this manner, developer and DBAs can work in harmony, and a DBA can optimize a query and change the database structure transparently to the developer.<BR/><BR/>Your article seems to say that you're using views to *test* your business logic, and you can then move it to the application, which I agree views are good for. I think for some permanent views, though, a stored procedure might be better (although if you find yourself putting 7 different input arguments to a stored procedure, perhaps a view would be better....)Sheeri K. Cabralhttp://www.blogger.com/profile/13990877688502800403noreply@blogger.com