SQL Server Emulation
Geoff Winkless
geoff at farmline.com
Wed Jun 20 10:13:27 EDT 2001
"Michael Peppler" <mpeppler at peppler.org> wrote:
: I'll respectfully disagree that using stored procs is a bad idea.
:
: (yes it hurts portability, but it allows for better performance, for
: data hiding, and for single location query tuning).
I'd agree if the amount of portability issues were minimal but essentially
once you've written a system to use MS SQL and SPs, you -cannot- move to a
different database without a rewrite.
That's not "hurting", that's repeatedly taking a very large sharp knife to
the jugular.
The performance gain does not justify the restrictions placed on the user
thereafter.
Geoff
More information about the FreeTDS
mailing list