Click here to Skip to main content
15,916,379 members
Home / Discussions / Database
   

Database

 
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 
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 
IMHO - do it in SQL.
Do running computations (via the select itself) and put the result in some temporary table - then use it as you wish...
Passing 4+ million records over the net can be very painful. How ever a well configured SQL with properly indexed table can handle 4+ million records with no problem...
Try to turn the dependencies into some parameters (pre-calculated maybe in the previous run or fixed from some external source) if you can, so even string manipulations will not slow you down...
In an optimal case you my turn it into some SQL job and left it alone for ages...
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: 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 
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
Richard Deeming13-Feb-14 2:51
mveRichard Deeming13-Feb-14 2:51 
GeneralRe: 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@Pune14-Feb-14 1:05
Dnyaneshwar@Pune14-Feb-14 1:05 
QuestionSQL query for availability Error Pin
Sniper 312-Feb-14 19:10
professionalSniper 312-Feb-14 19:10 

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.