Click here to Skip to main content
15,944,136 members
Home / Discussions / Database
   

Database

 
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 
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 
We will need to extract the records (probably up to 1m), process each record 36 to 120 times and write the information back to the DB.

The original data is already a copy, partially aggregated as much as possible.

Really not interested in getting into a processing farm, another team failed to do this and I'll stick to stored procs if that is a requirement. A commercial package takes approx 4 hours to process and we don't need their level of complexity so it should be do able.
Never underestimate the power of human stupidity
RAH

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 
QuestionIt Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Dnyaneshwar@Pune13-Feb-14 1:52
Dnyaneshwar@Pune13-Feb-14 1:52 
AnswerRe: It Should Print 12 but the output is NULL , Please tell me How to SET VALUE For the VAriable declare outside the SQL Text cretaed for dynamic query Pin
Dnyaneshwar@Pune13-Feb-14 2:15
Dnyaneshwar@Pune13-Feb-14 2:15 

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.