I would imagine that how to handle data is something that is specific to what you are trying to accomplish. A recent problem arose due to using ADO to update records. It would take ninety minutes to update the many thousands of records involved with multiple tables, which is unacceptable.
A stored procedure did the same task in 30 seconds. The original design did not have to consider a large number of records but no one told the users! :)
>
Walter, I hope there's plenty of room on your pedestal:
>
>http://codebetter.com/blogs/jeremy.miller/archive/2005/07/05/130093.aspx
>http://www.codinghorror.com/blog/archives/000292.html
>http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=28 >
>The beauty of google - it's easy to find just about anything you want. <s>
>
>Most of the people on this forum who have worked in both VFP and now .NET are general proponents of stored procedures. It's not just me, and I really find some of the reactions amusing.