Entity Framework performance tuning

  1. AddRange
  2. db.Configuration.AutoDetectChangesEnabled = false
Have to do some test...

留言

張貼留言

這個網誌中的熱門文章

Configure Application Insights on Windows Server of Azure Virtual Machine

圖片
According to these references, we can get telemetry data from virtual machine by these steps: Install Application Insights Status Monitor on Windows Server (VM). Update it to latest version. Run 'lusrmgr.msc' and add the IIS AppPool account(s) into 'Performance Monitor Users' group. Reset IIS. Reference: Instrument web apps at runtime with Application Insights Reference: Application insight monitor doesn't send data to portal due to insufficient permission
閱讀完整內容

修改Skype存放對話記錄、檔案的資料夾位置

因為MSN 要被消滅了 的賞味期限快到了，故開始轉換環境到Skype。 MSN預設存放對話記錄、檔案的地方可以在設定中修改，不過在Skype裡沒找到這個設定，故使用mklink的方式，將資料存在資料碟中，步驟如下： 將Skype關掉。 將原本Skype預設存放對話記錄、檔案的資料夾「C:\Users\使用者名稱\AppData\Roaming\Skype」整個剪下貼上到要存放的地方（EX. D:\Documents\Skype）。 用管理者權限打開cmd.exe，輸入指令「mklink /j "C:\Users\使用者名稱\AppData\Roaming\Skype" "D:\Documents\Skype"」，D槽是要存放的地方，依實際狀況修改。
閱讀完整內容

Minimize MS-SQL table deadlocks

There are two SPs perform complicated commands on the same table in our product. Our DBA said he didn't know how to reduce the deadlocks. After Google the key word 'minimizing deadlocks', I found this official document: Key-Range Locking According to above document and this  example , if I select data rows by parameter on non-unique index and then perform some operations, I will only lock these rows. Need some tests......
閱讀完整內容