Click here to Skip to main content
15,513,441 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionWeb database options Pin
Greg Hains22-Jul-20 0:40
Greg Hains22-Jul-20 0:40 
AnswerRe: Web database options Pin
Gerry Schmitz28-Jul-20 7:10
mveGerry Schmitz28-Jul-20 7:10 
GeneralRe: Web database options Pin
Greg Hains28-Jul-20 20:42
Greg Hains28-Jul-20 20:42 
GeneralRe: Web database options Pin
Gerry Schmitz30-Jul-20 1:19
mveGerry Schmitz30-Jul-20 1:19 
QuestionI have sql server database insert operation is very slow Pin
kali siddhu2-Jun-20 22:22
kali siddhu2-Jun-20 22:22 
AnswerRe: I have sql server database insert operation is very slow Pin
Mycroft Holmes3-Jun-20 14:35
professionalMycroft Holmes3-Jun-20 14:35 
GeneralRe: I have sql server database insert operation is very slow Pin
kali siddhu3-Jun-20 18:59
kali siddhu3-Jun-20 18:59 
GeneralRe: I have sql server database insert operation is very slow Pin
Mycroft Holmes4-Jun-20 13:15
professionalMycroft Holmes4-Jun-20 13: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 7:05
404byter27-May-20 7:05 
QuestionMaking data notation extending another language Pin
nedzadarek18-May-20 11:40
nedzadarek18-May-20 11:40 
GeneralRe: Making data notation extending another language Pin
Richard MacCutchan18-May-20 22:19
mveRichard MacCutchan18-May-20 22:19 
GeneralRe: Making data notation extending another language Pin
kalberts19-May-20 0:06
kalberts19-May-20 0:06 
GeneralRe: Making data notation extending another language Pin
Greg Utas19-May-20 1:41
mveGreg Utas19-May-20 1:41 
GeneralRe: Making data notation extending another language Pin
kalberts19-May-20 3:32
kalberts19-May-20 3:32 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 3:43
professionalEddy Vluggen19-May-20 3:43 
GeneralRe: Making data notation extending another language Pin
kalberts19-May-20 4:44
kalberts19-May-20 4:44 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 5:00
professionalEddy Vluggen19-May-20 5:00 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 3:38
professionalEddy Vluggen19-May-20 3:38 
GeneralRe: Making data notation extending another language Pin
kalberts19-May-20 5:36
kalberts19-May-20 5:36 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 8:12
professionalEddy Vluggen19-May-20 8:12 
GeneralRe: Making data notation extending another language Pin
kalberts19-May-20 9:44
kalberts19-May-20 9:44 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 11:08
professionalEddy Vluggen19-May-20 11:08 
GeneralRe: Making data notation extending another language Pin
nedzadarek19-May-20 11:21
nedzadarek19-May-20 11:21 
GeneralRe: Making data notation extending another language Pin
nedzadarek19-May-20 11:16
nedzadarek19-May-20 11:16 
GeneralRe: Making data notation extending another language Pin
Eddy Vluggen19-May-20 12:48
professionalEddy Vluggen19-May-20 12:48 

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.