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 
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 
kali siddhu wrote:
If i found matched record i am updating otherwise insert
Right there is your problem, for every record you are checking for an existing record and when you do the update the system has to check referential integrity.

Split your data into 2 set, those to be inserted and those to be updated. OR delete the records to be updated and insert all records. This may not be viable as it will break existing RI.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

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.