FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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