Delphi-PRAXiS

Delphi-PRAXiS (https://www.delphipraxis.net/forum.php)
-   Delphi-News aus aller Welt (https://www.delphipraxis.net/58-delphi-news-aus-aller-welt/)
-   -   Thread Safe ID Allocation Across Multiple RDBMSs (https://www.delphipraxis.net/206620-thread-safe-id-allocation-across-multiple-rdbmss.html)

DP News-Robot 13. Jan 2021 10:00

Thread Safe ID Allocation Across Multiple RDBMSs
 
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...


Alle Zeitangaben in WEZ +1. Es ist jetzt 09:33 Uhr.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO © 2011, Crawlability, Inc.
Delphi-PRAXiS (c) 2002 - 2021 by Daniel R. Wolf