Einzelnen Beitrag anzeigen

Benutzerbild von DP News-Robot
DP News-Robot

Registriert seit: 4. Jun 2010
14.959 Beiträge
 
#1

Thread Safe ID Allocation Across Multiple RDBMSs

  Alt 13. Jan 2021, 09:00
Believe it or Not, I have seen enterprise applications that simply perform a ‘select max(ID)+1 as NextID from <TableName>‘ in SQL against their RDBMS to get each and every ID value.* While this works, in a multi-threaded application, or on a busy SQL server this causes a lot of network traffic.However, the biggest problem with [...]

Weiterlesen...
  Mit Zitat antworten Zitat