Click here to Skip to main content
14,244,354 members
   

Database

 
GeneralRe: Best way to batchprocess a large update Pin
Richard Deeming29-May-19 1:12
mveRichard Deeming29-May-19 1:12 
GeneralRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 1:20
mve#realJSOP29-May-19 1:20 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson29-May-19 2:59
protectorJörgen Andersson29-May-19 2:59 
GeneralRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 5:13
mve#realJSOP29-May-19 5:13 
AnswerRe: Best way to batchprocess a large update Pin
#realJSOP29-May-19 1:14
mve#realJSOP29-May-19 1:14 
GeneralRe: Best way to batchprocess a large update Pin
Jörgen Andersson29-May-19 3:01
protectorJörgen Andersson29-May-19 3:01 
QuestionMongoDB Int Primary Key Pin
Kevin Marois17-May-19 8:41
professionalKevin Marois17-May-19 8:41 
AnswerRe: MongoDB Int Primary Key Pin
jschell18-May-19 7:09
memberjschell18-May-19 7:09 
Because the key is generated on the client not the server.
So if you only have one client, ever, then no not much of a problem. But if you want to add another server then it starts to be a problem.


MongoDB integer primary key (nodejs example) using server side functions[^]

In general the sort of things that a int id in a SQL database which might be solved are not the same as for NoSQL (mongodb). For example the overhead for storing each document (instance) is already so high that and saving with an int is almost insignificant. And if it is a matter of retrieval speed then look to some other solution that would provide real performance rather than the small (if any) gain that this might produce.
GeneralRe: MongoDB Int Primary Key Pin
Kevin Marois20-May-19 6:21
professionalKevin Marois20-May-19 6:21 
GeneralRe: MongoDB Int Primary Key Pin
jschell23-May-19 5:33
memberjschell23-May-19 5:33 
QuestionMySQL Pin
Member 1437004615-May-19 3:07
memberMember 1437004615-May-19 3:07 
AnswerRe: MySQL Pin
Richard MacCutchan15-May-19 3:12
protectorRichard MacCutchan15-May-19 3:12 
GeneralRe: MySQL Pin
Member 1437004615-May-19 20:24
memberMember 1437004615-May-19 20:24 
GeneralRe: MySQL Pin
Richard MacCutchan15-May-19 21:17
protectorRichard MacCutchan15-May-19 21:17 
GeneralRe: MySQL Pin
Member 1437004615-May-19 20:25
memberMember 1437004615-May-19 20:25 
GeneralRe: MySQL Pin
Richard MacCutchan15-May-19 21:18
protectorRichard MacCutchan15-May-19 21:18 
QuestionMySql vs MariaDB Pin
DerekT-P15-May-19 1:25
professionalDerekT-P15-May-19 1:25 
AnswerRe: MySql vs MariaDB Pin
Richard MacCutchan15-May-19 3:15
protectorRichard MacCutchan15-May-19 3:15 
AnswerRe: MySql vs MariaDB Pin
jschell18-May-19 7:18
memberjschell18-May-19 7:18 
GeneralRe: MySql vs MariaDB Pin
DerekT-P19-May-19 7:23
professionalDerekT-P19-May-19 7:23 
GeneralRe: MySql vs MariaDB Pin
jschell23-May-19 5:29
memberjschell23-May-19 5:29 
GeneralRe: MySql vs MariaDB Pin
DerekT-P23-May-19 8:22
professionalDerekT-P23-May-19 8:22 
GeneralRe: MySql vs MariaDB Pin
jschell2-Jun-19 8:36
memberjschell2-Jun-19 8:36 
QuestionWhat is an alias? Pin
Shraddha_Patel7-May-19 18:20
memberShraddha_Patel7-May-19 18:20 
AnswerRe: What is an alias? Pin
Richard MacCutchan7-May-19 21:23
protectorRichard MacCutchan7-May-19 21:23 

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.