Index
Our database has a specific limitation regarding index creation which affects how data can be queried:
Query Parameters Limitation:
You can perform queries using parameters. However, if a query involves more than two parameters, an index must be created to facilitate the search.
Index Creation Time:
Creating an index for complex queries (with more than two parameters) is not instantaneous. It can take several minutes to complete. This is necessary to ensure efficient data retrieval and maintain overall system performance.
Implications:
Plan Queries Accordingly: Be aware that querying with more than two parameters will result in a delay due to index creation.
System Performance: Index creation is an intensive process, and we have implemented this limitation to balance query flexibility with system stability.
This limitation is designed to optimize the performance and efficiency of data searches within our database, ensuring that the system remains responsive and reliable for all users.
Last updated