摘要：
对于用户定义表类型，它实际上并不能提高性能，会觉得它看起来高效的原因，是因为在程序中使用这个种类型的参数的时候，可以把 DataTable 做为参数直接传递给存储过程（看起来非常简洁）但实际上去Trace其行为，会发现其实它相当于把 DataTable 的值包装成了 insert 语句，而不是真正的把数据做为块传给存储过程DBA这边的建议是 1.对于少量数据，我们建议拼成 xml ，存储过程里面做解析（附件有一个开发那边提供的测试，对于少量数据，不足1万条，xml解析的性能并不差）. 2.对于大量数据，我们建立使用SqlBulkInsert 来处理.using System;using Sys 阅读全文
阅读排行榜
What is the single most influential book every programmer should read?
2012-08-28 09:53 by leo.wl2020, 341 阅读, 收藏,
摘要：
Code Complete(2nd edition) by Steve McConnellThe Pragmatic ProgrammerStructure and Interpretation of Computer ProgramsThe C Programming Languageby Kernighan and RitchieIntroduction to Algorithmsby Cormen, Leiserson, Rivest & SteinDesign Patternsby the Gang of FourRefactoring: Improving the Desig 阅读全文
Research Scientists and Engineers
2013-04-26 18:34 by leo.wl2020, 278 阅读, 收藏,
摘要：
Research Scientists and Engineershttp://research.google.com/people/jeff/Jeffrey DeanGoogle FellowI joined Google in mid-1999, and I'm currently a Google Fellow in the Systems Infrastructure Group. My areas of interest include large-scale distributed systems, performance monitoring, compression t 阅读全文
浙公网安备 33010602011771号