Click here to Skip to main content
14,241,414 members
   

Database

 
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 
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 
Kevin Marois wrote:
So what if I created a PK table on the sever:



In this scenario...

(some caller) -> (app server) -> (database server)

In the above the 'app server' is the 'client' for the 'database server'

If you create the key on the 'app server' then you have the following choices (locking in your code has no impact on this.)
1. There can only be one server.
2. You will need to create/find a mechanism the correlates the id creation between multiple 'app server' instances.
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 
AnswerRe: What is an alias? Pin
#realJSOP28-May-19 1:52
mve#realJSOP28-May-19 1:52 
QuestionHow can you get the alternate records from the table in the SQL? Pin
Shraddha_Patel30-Apr-19 22:53
memberShraddha_Patel30-Apr-19 22:53 

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.