I had requirement to test volume of the database how can I do it? Anybody can help with any web source with practical approach? My database is hosted on AWS (Aurora PostgreSQL)
3
-
What do you mean by volume?– João FariasCommented Sep 13, 2019 at 17:18
-
The amount of data in the database as rows .– Akhil_BuddhaCommented Sep 13, 2019 at 17:22
-
Maximum number of rows depends on the DB engine and (probably) the resources you have stackoverflow.com/a/2716470 I would say your question as it is now is too broad. If you could state the problem using the terms of your domain, the strategies you have thought/tried, and additional information, the contributors could suggest better a solution. meta.stackexchange.com/help/how-to-ask– João FariasCommented Sep 14, 2019 at 12:19
Add a comment
|
1 Answer
Write a test (in code) that does a query to the database. Select the count to check the number of records.
Reads:
- Learn how to use a database and SQL: https://www.codecademy.com/learn/learn-sql
- How to get the count with SQL: https://www.w3resource.com/sql/aggregate-functions/count-function.php
- More database test scenarios: https://www.tutorialspoint.com/etl_testing/etl_testing_scenarios.htm
answered Sep 15, 2019 at 10:35
