These days I am busy, I got a task to optimize the system we are maintaining.
There is a very complex view, it contains many tables, one of them has 4 million
data, so it consts several hours when the view is executed.
We thought and tried many ways,e.g. BCP and DTS, the BCP is amazing,
copy 4 million data from a text file to a table only costed 1 minute.
One month ago I will take an exam about Japanese, I am prepairing for it now,
I am not sure I can pass it, I will try my best.
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。