Forum Discussion
What query language are you using? How complex is your query? And how many records of product details do you have? Are you using keyword test or scripting?
- dpurnima2 months agoOccasional Contributor
I am using the Oracle SQLs(same as the app under test use) with different levels of complexities based on the web page, ensuring that each query returns only 1 row.
For the approach, I am planning to run a Javascript in the beginning to fetch rows from DB and initialise the data in some persistent variables, then use Keyword test that use this data to fill up the forms and validate the data returned on pages.
- rraghvani2 months agoChampion Level 3
Refer to https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/databases/index.html and try to use ADO Components, as it might be faster.
- dpurnima2 months agoOccasional Contributor
I tried with the ADO components as well, but the underlying queries are taking time, hence I am exploring options.
So kindly help me in setting up a local data storage/cache for my queries.
Related Content
- 7 years ago
Recent Discussions
- 8 hours ago
- 2 days ago