Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Inquiring method of information flows of social network site

A query method and technology of social networking sites, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of increasing database server load, increasing response time, etc., to reduce steps, reduce response time, and reduce load Effect

Inactive Publication Date: 2013-04-03
HANGZHOU YEYAOMAI ELECTRONICS BUSINESS
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to the existence of a large number of queries on social networking sites, when using existing query methods to query, the step of querying the database will greatly increase the load on the database server and increase the response time

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0021] A query method for information flow on social networking sites: firstly set the number a of data items displayed on a page in the database server, and then perform a query in the database according to a given condition according to a+1 items to obtain the query results, and then use the query results The number of entries is used to determine whether there is a next page, and finally the query results are displayed to reduce the number of queries to the database.

[0022] Use the number of query results to determine whether there is a next page. Specifically, compare the number of query results with the number a of data displayed on a page. If the number of query results is less than a+1, there will be no next page. If the number of query results is equal to a+1, there will be a next page.

[0023] In the database server, first set the number a of data items displayed on a page, and then perform a query in the database according to the given conditions according to a+1 ...

Embodiment 2

[0036] When the number a of displayed data on a page is 20, and the number of final query results is 19 according to given conditions, the invention is used for query.

[0037] A. In the database server, first set the number of data items displayed on a page a=20;

[0038] B. According to the given conditions, query in the database according to a+1=21 items, and get the query result b;

[0039] C. Use the count module to count the number c of the results in the query result b, c=19

[0040] D. Judging that the number c=19 is less than or equal to a+1=21, because c=19 is less than a+1=21, go to step E;

[0041] E. Display the query result b, and the query is completed.

[0042] When using the existing method to query, it is necessary to perform two steps of querying the database. For the first time, use the count module on the database server to query the total number of information streams to be displayed to determine whether there is a next page. Secondary query for the da...

Embodiment 3

[0045] When the number a of displayed data on a page is 20 and the number of final query results is 23, the invention is used for querying.

[0046] A. In the database server, first set the number of data items displayed on a page a=20;

[0047] B. According to the given conditions, query in the database according to a+1=21 items, and get the query result b;

[0048] C. Use the count module to count the number c of the results in the query result b, c=21;

[0049] D. Judging that the number c=19 is less than or equal to a+1=21, because c=21 is equal to a+1=21, go to step F;

[0050] F. Use the array_slice module to display the first a=20 pieces of data in the query result b, and then enter step G;

[0051] G. According to the given conditions, press a+1=21 to query the data in the database except for the already displayed data, and get the query result g;

[0052] H. Use the count module to count the number h of the results in the query result g, h=3;

[0053] I. Judging t...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses an inquiring method of information flows of a social network site. According to the method, the piece number a in one page of display data is set in advance in a database server, then, the inquiry is carried out in a database in accordance with a+1 pieces according to given conditions, inquiry results are obtained, then, the piece number of inquiry results is utilized for judging whether a next page exists or not, the inquiry results are finally displayed, and the times for inquiring the database is reduced. The inquiry that the piece number of once inquiry is one more than the piece number of one page of display data is carried out in the database server, then, the comparison of the inquiry results to the piece number of one page of display data is utilized for judging whether the next page exists or not, and the times for inquiring the database is reduced. By aiming at many inquiring times of the social network site, when the inquiring method is utilized, 40 percent of load of the database server during information flow paging can be reduced, and 30 percent of response time is reduced.

Description

technical field [0001] The invention relates to a query method for information flow of a social networking site, which belongs to the field of computers. Background technique [0002] In existing social networking sites, the information flow query needs to query the database twice or more to complete. For the first time, use the count module on the database server to query the total number of information flows to be displayed to determine whether there is a next page. , the second time the data used for displaying the current page is queried on the database server; if there are multiple pages of content, the above query needs to be repeated twice for each page displayed. Since social networking sites have a large number of queries, when using existing query methods to query, the step of querying the database will greatly increase the load on the database server and increase the response time. Contents of the invention [0003] The purpose of the present invention is to pr...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 姚海旗
Owner HANGZHOU YEYAOMAI ELECTRONICS BUSINESS
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com