Skip to Content.
Sympa Menu

freetds - Re: SQL Server Emulation

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: SQL Server Emulation
  • Date: Wed, 20 Jun 2001 07:36:36 -0700


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




Archive powered by MHonArc 2.6.24.

Top of Page