首页 > 其他 > 详细

Row versus Set Processing, Surprise!(集合处理和单行处理数据的差异性)

时间:2014-09-09 11:05:08      阅读:255      评论:0      收藏:0      [点我收藏+]

Row versus Set Processing, Surprise!

Craig Shallahamer:

1. Set based processing will likely be much faster than row based processing. Our experiment of processing 100K rows showed row based processing was 3700 times slower than set based processing. Not twice as slower or even 10 times slower… 3700 times slower! 
(差别在3700倍)
2. Compared to set based processing, row based processing times degrade much quicker than set based processing. That is, row based processing does not scale nearly as well as set based processing. We saw this in that the linear trend line for row based processing was 0.00259 compared to 0.00000 for set based processing.

Row versus Set Processing, Surprise!(集合处理和单行处理数据的差异性)

原文:http://www.cnblogs.com/caroline/p/3961494.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!