Click here to Skip to main content
15,889,116 members
Home / Discussions / Database
   

Database

 
AnswerRe: Conditional SQL commands: Good? Bad? Pin
Kornfeld Eliyahu Peter27-Jan-14 8:07
professionalKornfeld Eliyahu Peter27-Jan-14 8:07 
AnswerRe: Conditional SQL commands: Good? Bad? Pin
Gregory Gadow27-Jan-14 10:03
Gregory Gadow27-Jan-14 10:03 
AnswerRe: Conditional SQL commands: Good? Bad? Pin
Mycroft Holmes27-Jan-14 12:00
professionalMycroft Holmes27-Jan-14 12:00 
GeneralRe: Conditional SQL commands: Good? Bad? Pin
Kornfeld Eliyahu Peter27-Jan-14 20:45
professionalKornfeld Eliyahu Peter27-Jan-14 20:45 
GeneralRe: Conditional SQL commands: Good? Bad? Pin
Mycroft Holmes27-Jan-14 20:57
professionalMycroft Holmes27-Jan-14 20:57 
GeneralRe: Conditional SQL commands: Good? Bad? Pin
Kornfeld Eliyahu Peter27-Jan-14 21:02
professionalKornfeld Eliyahu Peter27-Jan-14 21:02 
GeneralRe: Conditional SQL commands: Good? Bad? Pin
Mycroft Holmes27-Jan-14 21:06
professionalMycroft Holmes27-Jan-14 21:06 
GeneralRe: Conditional SQL commands: Good? Bad? Pin
Kornfeld Eliyahu Peter28-Jan-14 23:28
professionalKornfeld Eliyahu Peter28-Jan-14 23:28 
Here it comes...
I got a personal info table - containing id, name, user, password, address, email and phone - with 19,245,718 records. The table has PK and indexes...
Run an insert/update of 108,382 records of which 32,190 where duplicated (same id).
With your method it took an average of 26.77 ms/record.
With the @@ROWCOUNT approach it took an average of 13.07 ms/record.
Both test run on the same machine with local SQL after restart.
The computer is a bit old one (one I can spare) with 4x2.93 CPU and 8GB memory, but I believe that the differences are real...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

GeneralRe: Conditional SQL commands: Good? Bad? Pin
Jörgen Andersson27-Jan-14 23:10
professionalJörgen Andersson27-Jan-14 23:10 
GeneralRe: Conditional SQL commands: Good? Bad? Pin
Richard Deeming28-Jan-14 1:34
mveRichard Deeming28-Jan-14 1:34 
GeneralRe: Conditional SQL commands: Good? Bad? Pin
Jörgen Andersson28-Jan-14 2:32
professionalJörgen Andersson28-Jan-14 2:32 
AnswerRe: Conditional SQL commands: Good? Bad? Pin
Shameel27-Jan-14 22:39
professionalShameel27-Jan-14 22:39 
AnswerRe: Conditional SQL commands: Good? Bad? Pin
jschell28-Jan-14 10:40
jschell28-Jan-14 10:40 
QuestionDatabase Design Tools? Pin
Code_Crash26-Jan-14 21:41
Code_Crash26-Jan-14 21:41 
AnswerRe: Database Design Tools? Pin
Richard MacCutchan26-Jan-14 21:58
mveRichard MacCutchan26-Jan-14 21:58 
AnswerRe: Database Design Tools? Pin
Jörgen Andersson27-Jan-14 1:36
professionalJörgen Andersson27-Jan-14 1:36 
GeneralRe: Database Design Tools? Pin
Code_Crash27-Jan-14 2:27
Code_Crash27-Jan-14 2:27 
AnswerRe: Database Design Tools? Pin
thatraja27-Jan-14 2:15
professionalthatraja27-Jan-14 2:15 
GeneralRe: Database Design Tools? Pin
Code_Crash27-Jan-14 2:31
Code_Crash27-Jan-14 2:31 
QuestionEntity framework Pin
columbos1492725-Jan-14 7:58
columbos1492725-Jan-14 7:58 
AnswerRe: Entity framework Pin
jschell25-Jan-14 13:01
jschell25-Jan-14 13:01 
AnswerRe: Entity framework Pin
S Douglas26-Feb-14 10:28
professionalS Douglas26-Feb-14 10:28 
GeneralMessage Closed Pin
25-Jan-14 3:18
anilkg2y25-Jan-14 3:18 
GeneralMessage Removed Pin
25-Jan-14 13:01
jschell25-Jan-14 13:01 
GeneralMessage Removed Pin
25-Jan-14 21:21
mveRichard MacCutchan25-Jan-14 21: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.