SQL Server Emulation
Michael Peppler
mpeppler at peppler.org
Wed Jun 20 10:36:36 EDT 2001
Geoff Winkless writes:
> "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.
Well - you could move it to Sybase without too much trouble.
> The performance gain does not justify the restrictions placed on the user
> thereafter.
That all depends on your requirements.
Michael
--
Michael Peppler - Data Migrations Inc. - mpeppler at peppler.org
http://www.mbay.net/~mpeppler - mpeppler at mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list at isug.com
More information about the FreeTDS
mailing list