I would like to know about the best way to store test data.
> Currently we have test data stored in excel sheet.
> The environment variables declared in the initialization pulls data from the excel sheet.
I want to know, if you have multiple test cases, multiple test data and some of the values have to be changed frequently, which would be the best way to have the data stored. I am looking for a solution which provides a better performance.
Would it be Excel itself?
Database connection ( This I think will take longer duration dues to connectivity).