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