If you call the OpenSearch API or use an OpenSearch SDK to push data, the total number of requests and the total size of data are limited. We recommend that you package the documents to be pushed and push the package. For more information, see Data push.
The search results depend on the number of documents that hit the keywords in the query. The more documents hit the keywords, the more calculations the system needs to perform, and the longer time is consumed. Therefore, an important optimization method is to reduce the number of documents that are retrieved for a query. For more information, see Document search.
OpenSearch supports JOIN operations on multiple tables. For information about related precautions, see Data synchronization latency caused by multi-table joins.