This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Use as many SPs as you can ( DB guys will be so happy that you use their junks :P)

redbird(不爱武装爱红妆)

1.Since it sits on the server and runs faster, you can use SP to handle complicated sql or sql with large chunk of data.

2. If you don't change(upgrade, downgrade, switch) the DB server very often, SP has more advantages.

3. It's sounds hard to write SP at first, but you will love it we you get use to it. Check the "sample" directory of DB and find some sample SP would be helpful.

4. Try not to put front end business logic into SP so that you might avoid frequently changes in SP.

Good Luck

(#1766004@0)
Last Updated: 2004-6-15
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / IT技术讨论 / 大家认为用stored procedure的好处和缺陷在哪里？是不是用得越多越好啊？当然，偶自己的答案是否定的，欢迎发言，谢谢！ -henhen(亨亨 ^_*); 2004-6-15 {32} (#1765871@0)
说累了偶提供从中国来的茶。：））

个人认为，只有当处理大量数据并产生少量结果时，SP才可以认为有些价值。 -xhis(枫下恩仇#13 xhis); 2004-6-15 (#1765876@0)

好久不见。：）） -henhen(亨亨 ^_*); 2004-6-15 (#1765896@0)

stored procedure is compiled so it is faster than sql statement.you can add permission to stored procedure so it more secure.also it prevent from sql injection which also make it more secure.... -nice2002(PlusTwo); 2004-6-15 (#1765901@0)

不错。：）） -henhen(亨亨 ^_*); 2004-6-15 (#1765906@0)
but stored procedure is less powerful than those high level language, certain things are very hard to do, and code is hard to read. -speed(如风); 2004-6-15 {155} (#1765938@0)
however, if u use MS SQL server, the coming SQL yukon supports using C# to write stored procedure, even though i haven't seen it, it seems very promising.

你标题上说的，偶太同意了，里面说的，没用过，是个好消息。 -henhen(亨亨 ^_*); 2004-6-15 (#1765948@0)

there is nothing wrong to use stored procedure with other language together.I only use stored procedure for db operation only, business logic is designed with other language such as C# -nice2002(PlusTwo); 2004-6-15 (#1765957@0)

100%同意。：）） -henhen(亨亨 ^_*); 2004-6-15 (#1765960@0)
我觉得有些可以写进SP的尽量写进SP，要该BUSINESS RULE的话，更新SP就一瞬间的事，可是那要更改中间TIRE就要重新编译，发布啥的，累。不过SP在测试的时候有点麻烦 -ningxin0809(雁影行洲); 2004-6-15 (#1765964@0)

可是那东西确实写起来不如其它高级语言方便，偶觉得business的东西还是分开。 -henhen(亨亨 ^_*); 2004-6-15 (#1765972@0)

我喜欢用SP，阿拉编的后台程序不见一个SQL，但是有个问题是， SP可移植性差，幸亏只用ORACLE，要不 SQL SERVER上转来穿去，估计就废了。 -ningxin0809(雁影行洲); 2004-6-15 (#1765931@0)

你居然是用甲骨文的，高！ -henhen(亨亨 ^_*); 2004-6-15 (#1765935@0)

没办法，早早就立志做烤古雪茄了：） -ningxin0809(雁影行洲); 2004-6-15 (#1765947@0)

各位高手，请帮忙 #1765839 -boer_ioi(我到了爱城); 2004-6-15 (#1765987@0)

try this -bluebluesky(bluebluesky); 2004-6-16 {82} (#1767000@0)
Set CustomerData = Robs.Execute("LookupCustomerByLastName " , LastNameFragement)

Use as many SPs as you can ( DB guys will be so happy that you use their junks :P) -redbird(不爱武装爱红妆); 2004-6-15 {513} (#1766004@0)
1.Since it sits on the server and runs faster, you can use SP to handle complicated sql or sql with large chunk of data.

2. If you don't change(upgrade, downgrade, switch) the DB server very often, SP has more advantages.

3. It's sounds hard to write SP at first, but you will love it we you get use to it. Check the "sample" directory of DB and find some sample SP would be helpful.

4. Try not to put front end business logic into SP so that you might avoid frequently changes in SP.

Good Luck

JJ是权威,在toronto吗？ -henhen(亨亨 ^_*); 2004-6-15 (#1766005@0)

It really depends. Case by case ... -ra_95(小人-生命换来的金钱); 2004-6-15 (#1766070@0)
Should be as few as possible. It is diffcult to maintain, not portable. Except in some case performance is more important. -bugkiller(Driver Coding); 2004-6-16 (#1766640@0)
个人认为应该尽量少用SP。SP的优点是执行效率高，速度快；缺点是难移植，难维护。相对于居高不下的开发和维护成本，执行效率的考虑在硬件不断进步的条件下已经可以退到一个相对次要的位置了。 -xanada(㊣流水); 2004-6-16 (#1766901@0)

Agree. -xhis(枫下恩仇#13 xhis); 2004-6-16 (#1766941@0)

效率高；尽可能使数据层和程序代码分离。 -dakandao(~相留醉~); 2004-6-16 (#1766963@0)
写的多可以显示水平高，老板刮目相看；让别人没法替代，就你一个人看得懂。 -vega_lee(包子-天津蓝领哥哥); 2004-6-16 (#1766967@0)

if i'm the manager, u will be fired first, too risky to keep going like this. -speed(如风); 2004-6-16 (#1767006@0)

it's not something a successfully boss would do. this issue should be solved before you would have to fire somebody. hehe -pasu(InTheSky); 2004-6-16 (#1767008@0)

i'm just joking here..:) anyway, bottom line is about attitude.. -speed(如风); 2004-6-16 (#1767012@0)

@Calgary

Use as many SPs as you can ( DB guys will be so happy that you use their junks :P)

Replies, comments and Discussions:

More Topics