dpurnima
2 months agoOccasional Contributor
Testcomplete : Loading DB data before triggering execution of keyword tests
I want to validate my Web page data for e.g. selected product details, with the data in the database. But the queries being slow, I want to run all the queries in the project in advance before triggering the actual executions. Sort of like a local data storage/cache.
Is there a way we can do it? Is there a better approach to handle this?
If you were to run the query in Oracle SQL, does it take as long?
It might be best to extract the information you require into a text file (or csv file), and read the data from that.