Click here to Skip to main content
14,739,709 members
Home » Discussions » C#
   

C#

 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
N a v a n e e t h4-Aug-08 19:28
MemberN a v a n e e t h4-Aug-08 19:28 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Togakangaroo5-Aug-08 3:16
MemberTogakangaroo5-Aug-08 3:16 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
darkelv4-Aug-08 20:22
Memberdarkelv4-Aug-08 20:22 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
leppie4-Aug-08 21:07
Memberleppie4-Aug-08 21:07 
JokeRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Harvey Saayman4-Aug-08 23:58
MemberHarvey Saayman4-Aug-08 23:58 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
PIEBALDconsult5-Aug-08 4:14
professionalPIEBALDconsult5-Aug-08 4:14 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
leppie5-Aug-08 4:56
Memberleppie5-Aug-08 4:56 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Ashfield4-Aug-08 22:16
MemberAshfield4-Aug-08 22:16 
I, like a lot of people, use stored procs extensively, mostly on reasonably large databases. Some of the reasons:

Network performance - why push extra data over the network (sp name + parameters as opposed to long sql statement)

Reuse, maintainability and consistency - if you have two applications doing the same query (perhaps with complex joins) and you need to change the query you change (and release) 1 proc, not 2 applications. You also ensure that all versions of the query are consistant and performance tuned - different developers have different skills, not everyone is good at sql.

Performance - I know that paramterised queries are cahced etc, but there are more opportunities for tuning with stored procs (some people may dispute that, thats their opinion)

There are other pros and cons, and everyone has differing opinions. I am possibly biased in that I have been contracting (mostly at large international financials) for many years, and all PRODUCTION applications have to access the database using stored procedures. This simplifies upgrades and bug fixes as you roll out a stored procedure to 1 server (possibly replicated) rather than several applications to users around the globe.

Bob
Ashfield Consultants Ltd

GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
PIEBALDconsult5-Aug-08 4:24
professionalPIEBALDconsult5-Aug-08 4:24 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Ashfield5-Aug-08 9:26
MemberAshfield5-Aug-08 9:26 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
Guffa4-Aug-08 22:42
MemberGuffa4-Aug-08 22:42 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
PIEBALDconsult5-Aug-08 4:26
professionalPIEBALDconsult5-Aug-08 4:26 
GeneralRe: I need to explain to our VP why trying to do everything in Stored Procedures is a bad idea Pin
nelsonpaixao5-Aug-08 14:32
Membernelsonpaixao5-Aug-08 14:32 
QuestionHow to finalize an object with an internal Thread ? Pin
ofeririko4-Aug-08 12:38
Memberofeririko4-Aug-08 12:38 
AnswerRe: How to finalize an object with an internal Thread ? Pin
led mike4-Aug-08 13:09
Memberled mike4-Aug-08 13:09 
AnswerRe: How to finalize an object with an internal Thread ? Pin
Guffa4-Aug-08 13:32
MemberGuffa4-Aug-08 13:32 
Questionobject oriented(class inheritance)??????? Pin
mr.mohsen4-Aug-08 11:57
Membermr.mohsen4-Aug-08 11:57 
AnswerRe: object oriented(class inheritance)??????? Pin
DaveyM694-Aug-08 12:03
professionalDaveyM694-Aug-08 12:03 
AnswerRe: object oriented(class inheritance)??????? Pin
DaveyM694-Aug-08 12:08
professionalDaveyM694-Aug-08 12:08 
AnswerRe: object oriented(class inheritance)??????? Pin
CodingYoshi4-Aug-08 13:37
MemberCodingYoshi4-Aug-08 13:37 
QuestionModify a file with a write only lock Pin
StevenWalsh4-Aug-08 11:38
MemberStevenWalsh4-Aug-08 11:38 
AnswerRe: Modify a file with a write only lock Pin
Paul Conrad4-Aug-08 11:43
professionalPaul Conrad4-Aug-08 11:43 
QuestionTrying to set the printer in printdialog Pin
baranils4-Aug-08 11:33
Memberbaranils4-Aug-08 11:33 
QuestionPDF Library Pin
CodingYoshi4-Aug-08 11:18
MemberCodingYoshi4-Aug-08 11:18 
AnswerRe: PDF Library Pin
Pete O'Hanlon4-Aug-08 11:27
mvePete O'Hanlon4-Aug-08 11:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.