Click here to Skip to main content
14,242,790 members
   

Database

 
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 
GeneralRe: MongoDB Int Primary Key Pin
Kevin Marois20-May-19 6:21
professionalKevin Marois20-May-19 6:21 
jschell wrote:
Because the key is generated on the client not the server.

So what if I created a PK table on the sever:
public int GetNextPrimaryKey(string collectionName)
{
    lock(_lockObj)
    {
        // Get the PrimaryKeys collection from the DB
        IMongoCollection<PrimaryKeyEntity> pkCol = GetCollection<PrimaryKeyEntity>("PrimaryKeys");

        // Attempt to find the row for the collection 
        PrimaryKeyEntity entity = pkCol.Find(x => x.CollectionName == collectionName).FirstOrDefault();

        // If it doesn't exist...
        if (entity == null)
        {
            // Create and insert the row for the desired collection
            entity = new PrimaryKeyEntity
            {
                PrimaryKey = 1,
                CollectionName = collectionName
            };
            pkCol.InsertOne(entity);
        }
        else
        {
            // Increment the PK
            entity.PrimaryKey = entity.PrimaryKey + 1;

            var filter = Builders<PrimaryKeyEntity>.Filter.Eq(x => x.CollectionName, collectionName);
            var update = Builders<PrimaryKeyEntity>.Update.Set(x => x.PrimaryKey, entity.PrimaryKey);
            var result = pkCol.UpdateOneAsync(filter, update).Result;
        }

        return entity.PrimaryKey;
    }
}
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

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 
AnswerRe: What is an alias? Pin
#realJSOP28-May-19 1:52
mve#realJSOP28-May-19 1:52 

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.