Click here to Skip to main content
15,945,109 members
Home / Discussions / Database
   

Database

 
QuestionDelete from MySQL + select affected Pin
Member 993503818-Feb-14 3:41
Member 993503818-Feb-14 3:41 
AnswerRe: Delete from MySQL + select affected Pin
Eddy Vluggen18-Feb-14 7:04
professionalEddy Vluggen18-Feb-14 7:04 
AnswerRe: Delete from MySQL + select affected Pin
ZurdoDev18-Feb-14 15:33
professionalZurdoDev18-Feb-14 15:33 
Questionoracle transaction with multi OracleConnection c # ? Pin
Member 1059782417-Feb-14 9:19
Member 1059782417-Feb-14 9:19 
AnswerRe: oracle transaction with multi OracleConnection c # ? Pin
Shameel18-Feb-14 0:00
professionalShameel18-Feb-14 0:00 
AnswerRe: oracle transaction with multi OracleConnection c # ? Pin
Simon_Whale18-Feb-14 0:46
Simon_Whale18-Feb-14 0:46 
QuestionHandling ISODate in mongoDB when Deserializing from JSON Pin
ThetaClear16-Feb-14 19:48
ThetaClear16-Feb-14 19:48 
QuestionWhere to do the processing Pin
Mycroft Holmes15-Feb-14 22:28
professionalMycroft Holmes15-Feb-14 22:28 
We have a requirement to do some serious record by record processing and I have had some suggestions to do the processing in c# rather than use a TDE or cursor. Personally I prefer TSQL but I suspect that is because that is what I am used to.

What has been suggested is that we use Dapper [^]and loops or linq to process the records then update back to the database. I will prefer using bulk copy to write the records back but that requires a datatable and converting from ORM List<> to data table for multi million recordsets may be detrimental to the performance.

Both processes would run on the same server or at least of the same spec.

Any opinions on which would be the fastest method of processing!

[edit] link recovery [\edit]
Never underestimate the power of human stupidity
RAH


modified 16-Feb-14 7:09am.

AnswerRe: Where to do the processing Pin
Eddy Vluggen15-Feb-14 23:25
professionalEddy Vluggen15-Feb-14 23:25 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 1:14
professionalMycroft Holmes16-Feb-14 1:14 
AnswerRe: Where to do the processing Pin
Kornfeld Eliyahu Peter15-Feb-14 23:30
professionalKornfeld Eliyahu Peter15-Feb-14 23:30 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 1:05
professionalMycroft Holmes16-Feb-14 1:05 
GeneralRe: Where to do the processing Pin
Kornfeld Eliyahu Peter16-Feb-14 1:14
professionalKornfeld Eliyahu Peter16-Feb-14 1:14 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 1:18
professionalMycroft Holmes16-Feb-14 1:18 
GeneralRe: Where to do the processing Pin
Kornfeld Eliyahu Peter16-Feb-14 1:27
professionalKornfeld Eliyahu Peter16-Feb-14 1:27 
GeneralRe: Where to do the processing Pin
Tim Carmichael16-Feb-14 7:43
Tim Carmichael16-Feb-14 7:43 
GeneralRe: Where to do the processing Pin
Mycroft Holmes16-Feb-14 11:44
professionalMycroft Holmes16-Feb-14 11:44 
AnswerRe: Where to do the processing Pin
GuyThiebaut17-Feb-14 0:17
professionalGuyThiebaut17-Feb-14 0:17 
GeneralRe: Where to do the processing Pin
Mycroft Holmes17-Feb-14 0:34
professionalMycroft Holmes17-Feb-14 0:34 
GeneralRe: Where to do the processing Pin
GuyThiebaut17-Feb-14 0:39
professionalGuyThiebaut17-Feb-14 0:39 
AnswerRe: Where to do the processing Pin
Jörgen Andersson17-Feb-14 0:59
professionalJörgen Andersson17-Feb-14 0:59 
AnswerRe: Where to do the processing Pin
jschell17-Feb-14 12:16
jschell17-Feb-14 12:16 
AnswerRe: Where to do the processing Pin
Nicholas Swandel21-Feb-14 8:46
Nicholas Swandel21-Feb-14 8:46 
Questionconvert mints into hours Pin
Member 1056208613-Feb-14 2:59
Member 1056208613-Feb-14 2:59 
AnswerRe: convert mints into hours Pin
Richard MacCutchan13-Feb-14 4:29
mveRichard MacCutchan13-Feb-14 4:29 

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.