Re:Stack Overflow Makes Slow Pages 100x Faster By Simple SQL...
by MartinCron on Tuesday May 03, 2011 @04:14PM
(#2511455)
Assuming all of your clients are all server-side (ie, servlets) and are also in source control, this should not be an issue.
Source control isn't the issue (of course everything is also in source control, this isn't the dark ages).
I'm talking about a pretty common scenario where you have one SQL server and 4 web servers acting as clients. Let's say you want to do a zero-downtime rolling deployment and upgrade the web servers one at a time while the other 3 continue to run. This is a real issue that I encountered on multiple projects that were adhering to the "everything must be in sprocs" dogma. Moving to ORMs and parameterized queries saves a lot of headaches.
Assuming all of your clients are all server-side (ie, servlets) and are also in source control, this should not be an issue.
If you have thick clients accessing SQL functions directly, you have a bigger problem (client-server... ugh) that browsers have solved.
If you have multiple servers talking to each other, you still have a version of the "thick client" problem, namely enterprise integration... for which there are intermediary APIs.