Click here to Skip to main content
15,437,521 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionWeb database options Pin
Greg Hains21-Jul-20 23:40
MemberGreg Hains21-Jul-20 23:40 
AnswerRe: Web database options Pin
Gerry Schmitz28-Jul-20 6:10
mveGerry Schmitz28-Jul-20 6:10 
GeneralRe: Web database options Pin
Greg Hains28-Jul-20 19:42
MemberGreg Hains28-Jul-20 19:42 
GeneralRe: Web database options Pin
Gerry Schmitz30-Jul-20 0:19
mveGerry Schmitz30-Jul-20 0:19 
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
mveGreg 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 

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.