ID management method and apparatus

Abstract

The invention provides an ID management method and apparatus. The method is applied to a terminal side, and comprises the steps of according to an ID obtaining request of a service data table, determining a corresponding local ID buffer pool queue, wherein the ID obtaining request of the service data table carries a service data table identifier; and if an available ID pool exists in the local IDbuffer pool queue, returning an ID in the available ID pool to a corresponding service data table according to the service data table identifier. According to the ID management method provided by theinvention, at the reception of the ID obtaining request, the terminal side does not need to send the ID obtaining request to a server side, and an ID can be obtained by directly invoking a local method; and therefore, the working efficiency is high, and the time consumption is little.

Description

technical field [0001] The present application relates to the field of computer technology, in particular to an ID management method and device, a computing device and a storage medium. Background technique [0002] With the continuous development of computer science and technology, the business scenarios of Internet products are becoming more and more complex. When the business development reaches a certain level, the traditional design of storing a certain business data in a single table in a single database will not be able to flexibly support business expansion. [0003] In order to meet the high-traffic and high-concurrency business scenarios, for a certain business, the concurrency capability of a single database and a single table will be very limited. From the perspective of business technology, sub-database and sub-table will allow the database to expand infinitely, and the concurrency capability is no longer limited to a single database. Theoretically, it will be t...

AI Technical Summary

Problems solved by technology

[0006] However, the implementation scheme of the existing technology cannot adjust the capacity of the ID buffer pool in real time. When the business volume grows too fast, the ID buffer pool is exhausted too quickly. At this time, the program needs to re-request the ID generator server to obtain a new ID buffer pool. When the business volume grows faster, the frequency of requesting the ID generator server will be faster, which will cause unexpected pressure on the ID generator server virtually.

[0007] In addition, after the ID in the ID buffer pool on the terminal side is exhausted, the terminal side re-initiates a remote call to obtain the ID buffer pool from the ID generator server, which will cause the program to block

If the capacity of the ID buffer pool is 10, it means that every time 10 records are inserted, a remote call will be triggered on the terminal side to request the ID generator server to obtain the ID buffer pool, resulting in serious blockage of the terminal side program

Images