JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » 交流、聊天、灌水  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友   
reply to postflat modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 Re:Software Fashion [Re:tempo]
singlelog

換回來



發文: 416
於 2003-10-09 02:06 user profilesend a private message to usersend email to singlelogreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
tempo wrote:
這是我的認知是:

1. stored procedure 就像是 perl 一樣, 沒有內建的 OO 處理..
程式一大了重複性就會提高, 所以不好 maintain..
而並非語法自己有問題..

2. stored procedure 跟程式放的位置不同, 處理不同, 所以 build 跟 test 的程序也不同..
對專案的自動化有影響..

3. stroed procedure 不可移植..這對於平台或應用軟體廠商多多少少有影響..

4. stored procedure 沒有 refactoring 工具, 沒有先進的 IDE 支援..Tounge


我聽過一種很喜歡的說法,Oracle是guru friendly。我想加一句, so is stored procedure。

不好maintain?如果程式寫得不好,用什麼語言寫都一樣難maintain啦。程式寫得好,思路清楚段落分明,這種程式寫成什麼語言都好maintain啦。

會用到stored procedure的場合中,通常也不會考慮到自動化...這些問題。

你說的都對,不過通常我們為了跨平台花了很多effort,真的跨得到嗎?跨db這種事情是聽過啦,不過通常performance就不怎麼樣。對於專案來說,跨platform就不是那麼重要了啦。真要做跨platform的人,其實我還真想問問你們,你們真的有在各種不同的platform下面測過嗎?否則你們怎麼敢掛這種保證呢?因為我是java,所以自動跨platform就ok嗎?

stored procedure 沒有 refactoring 工具, 沒有先進的 IDE 支援 => 對啦。要refactor stored procedure?這還真沒聽過。IDE?是啦。只能說stored procedure是guru-friendly。要當guru可是要有本事才行。


reply to postreply to post
我的書:專案管理Happy書!

我的網站:diggirl.net

my blog http://tinyurl.com/36gcye
話題樹型展開
人氣 標題 作者 字數 發文時間
10274 [精華] Software Fashion iampoya 1472 2003-10-08 17:49
8860 Re:Software Fashion singlelog 800 2003-10-08 20:49
8683 Re:Software Fashion im1000 3 2003-10-08 21:12
8775 Re:Software Fashion Biologic 2501 2003-10-08 21:16
8688 Re:Software Fashion tempo 523 2003-10-09 01:48
8690 Re:Software Fashion singlelog 865 2003-10-09 02:06
9229 Re:Software Fashion saijone 1356 2003-10-09 08:25
9260 Re:Software Fashion singlelog 1339 2003-10-09 09:27
8611 Re:Software Fashion tempo 1289 2003-10-09 09:51
8852 Re:Software Fashion singlelog 1720 2003-10-09 11:43
8594 Re:Software Fashion snpshu 343 2003-10-08 22:01
8683 Re:Software Fashion singlelog 527 2003-10-08 22:22
8556 Re:Software Fashion Biologic 222 2003-10-08 22:25
8747 Re:Software Fashion singlelog 82 2003-10-08 22:29
8492 Re:Software Fashion snpshu 162 2003-10-08 22:36
8607 Re:Software Fashion im1000 36 2003-10-08 23:18
8461 Re:Software Fashion anthonycs 106 2003-10-09 22:05
8371 Re:Software Fashion Biologic 178 2003-10-10 12:39
8502 Re:Software Fashion singlelog 738 2003-10-11 02:39
9923 Re:Software Fashion mason 231 2003-11-16 22:17
8548 Re:Software Fashion tempo 139 2003-10-09 01:57
8473 Re:Software Fashion ymshin 860 2003-10-09 18:13
8607 Re:Software Fashion singlelog 576 2003-10-09 21:16
8434 Re:Software Fashion snpshu 697 2003-10-09 23:04
8409 Re:Software Fashion sigma 355 2003-10-11 03:21
8303 Re:Software Fashion popcorny 293 2003-10-11 11:20
8335 Re:Software Fashion UndeadJ 251 2003-10-11 21:48
8263 Re:Software Fashion Biologic 122 2003-10-11 22:07
8619 Re:Software Fashion omega 475 2003-10-11 18:50
8311 Re:Software Fashion Biologic 343 2003-10-11 21:14
8247 Re:Software Fashion ymshin 333 2003-10-11 21:32
8272 Re:Software Fashion browser 165 2003-10-12 01:10
8205 Re:Software Fashion delta 128 2003-10-12 17:14
8241 Re:Software Fashion Biologic 78 2003-10-12 17:28
8100 Re:Software Fashion ymshin 115 2003-10-13 14:01
8381 Re:Software Fashion sigma 426 2003-10-12 12:08
8123 Re:Software Fashion omega 164 2003-10-13 13:34
8112 Re:Software Fashion sigma 220 2003-10-14 00:33
8184 Re:Software Fashion singlelog 259 2003-10-14 00:46
8086 Re:Software Fashion anthonycs 273 2003-10-14 00:48
8425 Re:Software Fashion singlelog 733 2003-10-12 02:37
8257 Re:Software Fashion anthonychen 206 2003-10-12 02:43
8407 Re:Software Fashion jini 1569 2003-10-12 13:54
8044 Re:Software Fashion sigma 128 2003-10-14 00:41
8128 Re:Software Fashion jini 166 2003-10-14 00:48
8137 Re:Software Fashion jini 80 2003-10-12 19:20
8063 Re:Software Fashion jini 45 2003-10-14 01:50
8172 Re:Software Fashion moliwang 160 2003-10-14 03:00
» JWorld@TW »  交流、聊天、灌水

reply to postflat modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8