Method and device for storing indexes of dynamic messages

Abstract

The invention discloses a method and a device for storing indexes of dynamic messages. The method comprises the steps of setting an index database which is used for storing the indexes of the dynamic messages, wherein the index database comprises M groups of time shaft index tables, and each group of time shaft index tables comprise N time shaft index tables; dividing user IDs (Identifications) into M groups; enabling the M groups of user IDs to be in one-to-one correspondence to the M groups of time shaft index tables, wherein when the indexes of the dynamic messages which are issued by users are stored, the indexes of the dynamic messages of the same user can be stored in the N time shaft index tables in one corresponding group in a rotating way according to issued time and a principle that the indexes are rotated once every fixed time interval, at least rotating time points of a part of the users are mutually staggered, thus at least table skipping time points of the time shaft index tables of a part of the users are staggered, table skipping is carried out in different time points, and thus the problems in a specific time point that the database visiting volume is increased in a doubling way due to large table skipping operation quantity, and thus database crashing can be further caused are relieved; index table distribution can be carried out in the same way, and the same beneficial effect can also be obtained.

Description

technical field [0001] The invention relates to the technical field of computer networks, in particular to a method and device for storing an index of dynamic messages. Background technique [0002] Social Networking Services (SNS, Social Networking Services) specifically refers to Internet application services designed to help people build social networks. For example, various social networking sites that are popular at present, as well as interpersonal relationship network services provided by other portal websites, such as Weibo, contact relationship services provided by instant messaging systems, etc. [0003] In order to provide this kind of human relationship service, it is necessary to save dynamic messages (generally called feeds) published by SNS users in the background, so that users or their contacts can query dynamic messages from each other. [0004] As SNS is loved by a large number of users, its background data has also increased exponentially, and data conge...

AI Technical Summary

Problems solved by technology

[0016] In view of this, the present invention provides a method and device for storing an index of dynamic messages to solve the problem in the prior art that the number of database visits increases exponentially due to the large number of table jump operations in the same date

Images