Click here to Skip to main content
14,579,188 members

Design and Architecture

 
QuestionMessage Closed Pin
6-Jul-20 19:13
Membervigapl987126-Jul-20 19:13 
QuestionMessage Closed Pin
3-Jul-20 22:23
Membervigahy654223-Jul-20 22:23 
QuestionI have sql server database insert operation is very slow Pin
kali siddhu2-Jun-20 21:22
Memberkali siddhu2-Jun-20 21:22 
AnswerRe: I have sql server database insert operation is very slow Pin
Mycroft Holmes3-Jun-20 13:35
professionalMycroft Holmes3-Jun-20 13:35 
Be very sure you are only doing and insert, not an update.

We created a stored proc that removed all indexes except the PK on the destination tables. applied the insert and then rebuilt the indexes.

CAVEAT your data MUST be clean as you lose all referential integrity checking.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

GeneralRe: I have sql server database insert operation is very slow Pin
kali siddhu3-Jun-20 17:59
Memberkali siddhu3-Jun-20 17:59 
GeneralRe: I have sql server database insert operation is very slow Pin
Mycroft Holmes4-Jun-20 12:15
professionalMycroft Holmes4-Jun-20 12:15 
Questiondesigning programs Pin
404byter27-May-20 6:05
Member404byter27-May-20 6:05 
QuestionMaking data notation extending another language Pin
nedzadarek18-May-20 10:40
Membernedzadarek18-May-20 10:40 
GeneralRe: Making data notation extending another language Pin
Richard MacCutchan18-May-20 21:19
mveRichard MacCutchan18-May-20 21:19 
GeneralRe: Making data notation extending another language Pin
Member 798912218-May-20 23:06
MemberMember 798912218-May-20 23:06 
GeneralRe: Making data notation extending another language Pin
Greg Utas19-May-20 0:41
professionalGreg Utas19-May-20 0:41 
GeneralRe: Making data notation extending another language Pin
Member 798912219-May-20 2:32
MemberMember 798912219-May-20 2:32 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 2:43
professionalEddy Vluggen19-May-20 2:43 
GeneralRe: Making data notation extending another language Pin
Member 798912219-May-20 3:44
MemberMember 798912219-May-20 3:44 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 4:00
professionalEddy Vluggen19-May-20 4:00 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 2:38
professionalEddy Vluggen19-May-20 2:38 
GeneralRe: Making data notation extending another language Pin
Member 798912219-May-20 4:36
MemberMember 798912219-May-20 4:36 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 7:12
professionalEddy Vluggen19-May-20 7:12 
GeneralRe: Making data notation extending another language Pin
Member 798912219-May-20 8:44
MemberMember 798912219-May-20 8:44 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 10:08
professionalEddy Vluggen19-May-20 10:08 
GeneralRe: Making data notation extending another language Pin
nedzadarek19-May-20 10:21
Membernedzadarek19-May-20 10:21 
GeneralRe: Making data notation extending another language Pin
nedzadarek19-May-20 10:16
Membernedzadarek19-May-20 10:16 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 11:48
professionalEddy Vluggen19-May-20 11:48 
GeneralRe: Making data notation extending another language Pin
Member 798912219-May-20 13:12
MemberMember 798912219-May-20 13:12 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 14:21
professionalEddy Vluggen19-May-20 14:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.