Systems and methods for query optimization

摘要

The present disclosure relates to systems and methods for performing search queries and for query optimization. In accordance with certain embodiments, a query from a client may be received at a server, and a default query range (e.g., a period of time, or other factor) may be applied to the query. The query may be executed in a first execution using an index comprising a category of information stored in the database and subject to the default query range. If the number of query results from the first execution is outside a predetermined range, then the query range may be adjusted to obtain a number of query results closer to or within the predetermined range. Additionally, the query may be executed in a second execution using the index comprising the category of information stored in the database and subject to the adjusted query range. The query results obtained from the second execution of the query may be sent to the client.

主权项

1. A computer-implemented system, comprising:
one or more storage media that store a plurality of instructions; and at least one processor that executes the plurality of instructions to perform the following operations: receiving a query from a client device; identifying a query range based on a content type associated with the received query; executing, as part of a first execution, the received query on a database in accordance with the identified query range; determining a number of query results based on the first execution of the received query; adjusting the query range when the determined number of query results from the first execution is outside a predetermined range, wherein adjusting the query range comprises increasing the query range when the determined number of query results is below the predetermined range; storing the adjusted query range for use with future queries; executing, as part of a second execution, the received query on the database in accordance with the adjusted query range; and identifying, in response to the second execution, query results based on the adjusted query range.