@andre-senna My proposal is to create two distinct environments: one with a standalone database and another configured with sharding. Both environments should have data loaded and indexes set up according to the requirements of the queries to be executed. A script will be developed to run a series of queries on both databases using the defined indexes. At the end of the process, a comparative chart will be generated showing the average query execution times for each configuration, allowing us to evaluate the impact of sharding on performance. Additionally, a document will be created to explain the test methodology, the infrastructure components used, and a conclusion describing the results obtained.
@andre-senna My proposal is to create two distinct environments: one with a standalone database and another configured with sharding. Both environments should have data loaded and indexes set up according to the requirements of the queries to be executed. A script will be developed to run a series of queries on both databases using the defined indexes. At the end of the process, a comparative chart will be generated showing the average query execution times for each configuration, allowing us to evaluate the impact of sharding on performance. Additionally, a document will be created to explain the test methodology, the infrastructure components used, and a conclusion describing the results obtained.